SPOOL SPACE ISUUE WHILE RUNNING A BTEQ

Database
Enthusiast

SPOOL SPACE ISUUE WHILE RUNNING A BTEQ

In one my process bteq is failing due to "NO MORE SPOOL SPACE to user”. when i executed it from SQL assitant the select query used in bteq is working fine and returning rows but when the same query is used with insert statement is giving “NO MORE SPOOL SPACE to user”.

Please help on this.

Regards,
Vikas

2 REPLIES
Enthusiast

Re: SPOOL SPACE ISUUE WHILE RUNNING A BTEQ

Can u please post your query (masking the tablenames if u cannot share tablenames)?

Ideally this should not happen.

If you have already found a solution can u please share your findings?

Enthusiast

Re: SPOOL SPACE ISUUE WHILE RUNNING A BTEQ

This was due to incorrect data in the source table. Once data is corrected problem get resolved.

Thanks,
Vikas