JCL for unloading large tables



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

JCL for unloading large tables

Postby ramganesht » Tue Jun 05, 2012 2:22 am

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
 
Posts: 1
Joined: Thu May 31, 2012 9:57 pm
Has thanked: 0 time
Been thanked: 0 time

Re: JCL for unloading large tables

 

Re: JCL for unloading large tables

Postby Akatsukami » Tue Jun 05, 2012 2:36 am

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.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: JCL for unloading large tables

Postby steve-myers » Tue Jun 05, 2012 7:39 am

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.
steve-myers
Global moderator
 
Posts: 1885
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 197 times

Re: JCL for unloading large tables

Postby dick scherrer » Tue Jun 05, 2012 8:26 am

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).
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: JCL for unloading large tables

Postby Anuj Dhawan » Tue Jun 19, 2012 10:28 am

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?
Anuj
Anuj Dhawan
 
Posts: 274
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times

Re: JCL for unloading large tables

Postby NicC » Tue Jun 19, 2012 11:43 am

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: JCL for unloading large tables

Postby dick scherrer » Tue Jun 19, 2012 7:09 pm

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
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: JCL for unloading large tables

Postby Anuj Dhawan » Wed Jun 20, 2012 10:46 am

I agree with you Nic, but that's a behavior usually observed on these forums...
Anuj
Anuj Dhawan
 
Posts: 274
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post