Page 1 of 1

JCL for unloading large tables

PostPosted: Tue Jun 05, 2012 2:22 am
by ramganesht
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.

Re: JCL for unloading large tables

PostPosted: Tue Jun 05, 2012 2:36 am
by Akatsukami
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.

Re: JCL for unloading large tables

PostPosted: Tue Jun 05, 2012 7:39 am
by steve-myers
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.

Re: JCL for unloading large tables

PostPosted: Tue Jun 05, 2012 8:26 am
by dick scherrer
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).

Re: JCL for unloading large tables

PostPosted: Tue Jun 19, 2012 10:28 am
by Anuj Dhawan
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?

Re: JCL for unloading large tables

PostPosted: Tue Jun 19, 2012 11:43 am
by NicC
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.

Re: JCL for unloading large tables

PostPosted: Tue Jun 19, 2012 7:09 pm
by dick scherrer
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

Re: JCL for unloading large tables

PostPosted: Wed Jun 20, 2012 10:46 am
by Anuj Dhawan
I agree with you Nic, but that's a behavior usually observed on these forums...