IBM Mainframe Forum

I am trying to unload a DB2 table which as many as 3 crore rows, and I am using DSNUPROC utility in my JCL, but the job always fails and some times the utility is being crashed. Is there any other utility which can be used to unload a the large table.

ramganesht wrote:I am trying to unload a DB2 table which as many as 3 crore rows, and I am using DSNUPROC utility in my JCL, but the job always fails and some times the utility is being crashed. Is there any other utility which can be used to unload a the large table.

It's very unlikely to be a problem with DSNUPROC per se, and very unlikely to be solved by using a different program. Post the JCL and message log of the failing job, using the Code tags as necessary to preserve alignment and formatting.

There are two problems here.

• The "crore" term is not commonly used outside of India, What does it mean????
• You just say "it does not work," without providing any clues as to output messages and codes from your test, or providing us with the JCL you did use. No one can help you without this information.

Hello,

So you are trying t unload 30,000,000 rows. . .

How many bytes per unloaded row?

With the little you've provided, my guess is that there is a space problem for the output.

If you post the diagnostic info, we can see if this is the problem or if there is something else.

As mentioned - do NOT post "it didn't work" (which is the biggest waste of forum space and people's time).

ramganesht wrote:I am trying to unload a DB2 table which as many as 3 crore rows, and I am using DSNUPROC utility in my JCL, but the job always fails and some times the utility is being crashed. Is there any other utility which can be used to unload a the large table.

What do you mean by "crash" here? A(n) SB37 or something else?

2 weeks without a single response from OP: I guess we can assume he has it fixed and the topic can be deleted as it does nothing to enhance anyone's abilities.

Hi Nic,

As this was the first post from TS, i'd hoped to see some folllowup.

I sent a PM asking for an update. . .

d

I agree with you Nic, but that's a behavior usually observed on these forums...