View previous topic :: View next topic
|
Author |
Message |
apsar.kogatam Warnings : 1 New User
Joined: 27 Jun 2008 Posts: 33 Location: CHENNAI
|
|
|
|
Hi Team,
I have coded a Jcl to load multiple db2 tables at same time by calling the same proc each and every time.My jcl is working fine but i have coded a jcl to load 13 db2 tables but the code is loading the data only to 4 tables other tables are empty.I didn't see any error message for the empty tables.Please help me what could be the reason for the tables empty.
//jobcard
//ACTRNSUM EXEC PGM=MULTIGEN
//*
//SYSUT1 DD DSN=JEUST.JEI700.ACTRNSUM.UNLOAD,
// DISP=SHR,
// UNIT=SYSDA
//SYSUT2 DD DSN=JEUST.JEI800.ACTRNSUM.UNLOAD.BKUP(+1),
// DISP=(MOD,CATLG,DELETE),
// LRECL=42,BLKSIZE=32592,RECFM=FB,
// UNIT=SYSDA
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//***********************************************************
//********* APCTR TABLE UNLOAD BACKUP *********************
//***********************************************************
//APCTR EXEC PGM=MULTIGEN
//*
//SYSUT1 DD DSN=JEUST.JEI700.APCTR.UNLOAD,
// DISP=SHR,
// UNIT=SYSDA
//SYSUT2 DD DSN=JEUST.JEI800.APCTR.UNLOAD.BKUP(+1),
// DISP=(MOD,CATLG,DELETE),
// LRECL=28,BLKSIZE=27972,RECFM=FB,
// UNIT=SYSDA
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
LIKE THIS I TOOK THE BKUP FOR ALL 13 TABLES
NEXT THE FOLLWING CODE
//TABLE01 EXEC JS010,LOADDATA='JEUST.JEI800.ACTRNSUM.UNLOAD.BKUP(0)',
// CNTLCARD='JEUST.JEI800.ACTRNSUM.UNLOAD.LOADCARD'
//*
//TABLE02 EXEC JS010,LOADDATA='JEUST.JEI800.APCTR.UNLOAD.BKUP(0)',
// CNTLCARD='JEUST.JEI800.APCTR.UNLOAD.LOADCARD'
//*
:
:
:
:
:
:
SAME IS REPATED FOR 13 TABLES WITH DIFFERENT BKUP's and load cards.
PROC FOR ALL 13 TABLES
====
//JS010 PROC
//STEP1 EXEC PGM=DSNUTILB,REGION=0M,
// PARM='DB2T,UT943801'
//SYSREC01 DD DISP=SHR,DSN=&LOADDATA
//SYSIN DD DISP=SHR,DSN=&CNTLCARD
//SYSUT1 DD SPACE=(CYL,(500,250)),UNIT=SYSDA
//SORTOUT DD SPACE=(CYL,(500,250)),UNIT=SYSDA
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
LOADCARD DATA
=============
LOAD DATA INDDN SYSREC01 REPLACE INTO TABLE
DA53.T535702
(
STATUS_CD POSITION( 1 )
CHAR( 1) ,
EFFECTIVE_DT POSITION( 2 )
DATE EXTERNAL( 10) ,
BC_CD POSITION( 12 )
CHAR( 3) ,
SYS_CD POSITION( 15 )
CHAR( 3) ,
COST_CENTER_NO POSITION( 18 )
CHAR( 3) ,
FIN_GEO_LOC_CD POSITION( 21 )
CHAR( 3) ,
FIN_REG_CD POSITION( 24 )
CHAR( 2) ,
LEDGER_UNIT_NO POSITION( 26 )
CHAR( 3)
)
like the above i have 13 control cards with different table sapces and columns. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10886 Location: italy
|
|
|
|
Quote: |
Please help me what could be the reason for the tables empty. |
sorry psychic day will be on friday, You will have to wait a few hours
what have You tried to debug the issue??
you did not show the unload step, only some multigen mangling on the
unloaded data.
maybe there is nothing to load after all! |
|
Back to top |
|
|
apsar.kogatam Warnings : 1 New User
Joined: 27 Jun 2008 Posts: 33 Location: CHENNAI
|
|
|
|
Hi enrico,
In Multigen steps i have unloaded datasets xcomed from production to test.i am taking the bkup for the same datsets and giving input as a load data to test region since the same data should be loaded to test tables. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10886 Location: italy
|
|
|
|
Quote: |
I didn't see any error message for the empty tables.Please help me what could be the reason for the tables empty. |
again... the question to ask is...
do the unloaded dataset contain any data???
also I hope that You ran two different jobs
one for the multigen stuff the other for the reload...
You are using xxxx(+1) and xxxx(0), meditate on the rollin ruled for gdgs |
|
Back to top |
|
|
apsar.kogatam Warnings : 1 New User
Joined: 27 Jun 2008 Posts: 33 Location: CHENNAI
|
|
|
|
Hi enrico,
All the unloaded datsets contains the data.I ran a single job with first mutigen steps and TABLE01---TABLE13. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10886 Location: italy
|
|
|
|
Quote: |
All the unloaded datsets contains the data.I ran a single job with first mutigen steps and TABLE01---TABLE13. |
then... meditate strongly on GDGs roll-in rules
gdgdataset(+1) will become gdgdataset(0) only at the end of the job
You are using the previous generation
as hinted in my previous reply
Quote: |
also I hope that You ran two different jobs
one for the multigen stuff the other for the reload...
You are using xxxx(+1) and xxxx(0), meditate on the roll-in rules for gdgs
|
|
|
Back to top |
|
|
apsar.kogatam Warnings : 1 New User
Joined: 27 Jun 2008 Posts: 33 Location: CHENNAI
|
|
|
|
Thanks for informing but i tried exceuting the /jcl with (+1) itself at all the places still the same result.and please find the UTPRINT statements for the empty tables.
Code: |
0 OPTIONS: NULLOUT=RC0
0 DC 0 TC 0 CS DSVVV KSZ 18 VSZ 18
0 FSZ=12252 RU IGN=0 C AVG=24 0 WSP=383 U DYN=0 0
1 DE-BASE D5-BASE D9-BASE E8-K48846
0 OUTPUT LRECL = 23, TYPE = F
0 IN MAIN STORAGE SORT
0 INSERT 12252, DELETE 12252
0 RECORDS - IN: 0, OUT: 0
0 NUMBER OF BYTES SORTED: 281796
0 RECORDS SORTED - PROCESSED: 12252, EXPECTED: 12252
0 TOTAL WORK DATA SET TRACKS ALLOCATED: 0 , TRACKS USED: 0
0 MEMORY OBJECT STORAGE USED = 0M BYTES
0 HIPERSPACE STORAGE USED = 0K BYTES
0 DATA SPACE STORAGE USED = 0K BYTES
0 END OF DFSORT |
|
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10886 Location: italy
|
|
|
|
well it' s about time for Your support to take their lazy *** off the chair and start helping You.
very little we can do from here without having first hand access to Your environment
debugging is easy when You see everything with Your eyes, peripheral vision gives lots of hints
in this case a question/answers back and forth will simply be an unpleasant waste of time and a delay in getting a solution |
|
Back to top |
|
|
apsar.kogatam Warnings : 1 New User
Joined: 27 Jun 2008 Posts: 33 Location: CHENNAI
|
|
|
|
Hi enrico,
One more problem i am facing here is i coded the jcl to load only 13 tables but after exceuting my jcl other tables which i didn't code in jcl has DA53.tablespace also getting emptied.Totally confused why other tables with DA53.* also getting emptied. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10886 Location: italy
|
|
|
|
are You sure that the cntlcard datasets contain the right info???
why don' t You start all over using one job <==> one table ,
piling up things is never a good approach when debugging |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Enrico,
maybe you start a chat session, having this 1-1 conversation. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10886 Location: italy
|
|
|
|
Hi Peter,
i' ll stop shortly, no reason to waste bandwidth
very little or better nothing can be done without having access to the faulty environment |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Enrico,
i agree.
But i have never seen someone with this kind of patience.
And that for an Italian |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hello There,
I have few question which I want to clarify :
Can you double check that all the unload dataset contain Data?
Secondly Please confirm that those 13 tables belongs to different Table space as you specified Replace in Load Cards?
Thirdly what your sysout says is it showing Number of rows laoded as 0
|
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10886 Location: italy
|
|
|
|
Thank You Peter!
Usually around here I am bashed for my bad manners ! |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Moderators getting bashed? I wouldnt dare. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
One simple thing that is easily overlooked is loading different tables within the same tablespace.
LOAD REPLACE empties the complete tablespace ! |
|
Back to top |
|
|
|