View previous topic :: View next topic
|
Author |
Message |
razesh84
New User
Joined: 05 Apr 2010 Posts: 41 Location: Kolkata,India
|
|
|
|
Hi,
I was trying to run a query through SYNCSORT.I got the below job from net & changed it to my needs.but the job abended.
Code: |
//SORTSQL EXEC PGM=SYNCSORT,PARM='DB2=D01G'
//$ORTPARM DD *
VSCORE=5M,VSCORET=40M,MINCORE=5000K
OPTION MAINSIZE=40M
//SYSOUT DD SYSOUT=*
//SORTOUT DD SYSOUT=*
//SORTIN DD DUMMY
//SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,20)
//SORTWK02 DD UNIT=SYSDA,SPACE=(CYL,20)
//SORTDBIN DD *
SELECT TRADE_DATE,SETT_DATE
FROM HUM.TRANS
//SYSIN DD *
SORT FIELDS=COPY
//*
|
sysout display
Code: |
$ORTPARM : VSCORE=5M,VSCORET=40M,MINCORE=5000K
OPTION MAINSIZE=40M
SYSIN :
SORT FIELDS=COPY
*
WER161B ALTERNATE PARM USED
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
|
i'm not sure whats wrong with the SYSIN card.
its not that i'll be using SYNCSORT from now on to hit DB2 but a successful run of this job would definitley make me happier |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Do you have at least one blank before SORT FIELDS=...? It doesn't show in your post... |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
I agree with Bill and I also believe that this statement has enough hints to get you going:
Code: |
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT |
, no? |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
razesh84 wrote: |
but a successful run of this job would definitley make me happier |
Also make sure you are having the DB2 loadlib PDSs in the JOBLIB/STEPLIB. |
|
Back to top |
|
|
razesh84
New User
Joined: 05 Apr 2010 Posts: 41 Location: Kolkata,India
|
|
|
|
thanks all
after changing the sysin card it again went down with S806 for DB2 load module DSNACAB
Code: |
CSV003I REQUESTED MODULE DSNACAB NOT FOUND
|
added DB2 loadlibs as suggested by arun it went smooth |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
razesh84 wrote: |
added DB2 loadlibs as suggested by arun it went smooth |
Glad to hear it worked |
|
Back to top |
|
|
razesh84
New User
Joined: 05 Apr 2010 Posts: 41 Location: Kolkata,India
|
|
|
|
Arun,
I guess u r using syncsort to unload DB2 tables in your shop.Can you tell me is there any advantage of using syncsort.
Currently, i noticed that it allows DB2 functions & joins while unload.
Yet to compare its reuslt with DSNUTILB or DSNTIAUL. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Quote: |
I guess u r using syncsort to unload DB2 tables in your shop |
No, Mostly it is the DB2 High Performance Unload or the DB2 Unload DSNTIAUL. I doubt if the sort product can perform well over these.
Anyways you could try out and let us know since you have all "working" now |
|
Back to top |
|
|
razesh84
New User
Joined: 05 Apr 2010 Posts: 41 Location: Kolkata,India
|
|
|
|
Quote: |
DB2 High Performance Unload |
r u using platinum high performance unload with PTLDRIVM utility? |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
No, its IBM DB2 HPU. |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Yes. Syncsort can be used to extract the data from DB2. |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
The words are "are you" not "r u" |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Quote: |
I guess u r using syncsort |
Here is another one. Has probably to do with tanslation from Sanskit to English? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Quote: |
Has probably to do with tanslation from Sanskit to English? |
Or too much time spent texting. . .
Chatroom/kiddie texting has no place really in a professional setting. . .
d |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
...Only if they understand this...amen. |
|
Back to top |
|
|
|