IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

No data found when loading multiple tables


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
apsar.kogatam
Warnings : 1

New User


Joined: 27 Jun 2008
Posts: 33
Location: CHENNAI

PostPosted: Thu Jan 28, 2010 12:34 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Thu Jan 28, 2010 12:38 pm
Reply with quote

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
View user's profile Send private message
apsar.kogatam
Warnings : 1

New User


Joined: 27 Jun 2008
Posts: 33
Location: CHENNAI

PostPosted: Thu Jan 28, 2010 12:47 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Thu Jan 28, 2010 12:56 pm
Reply with quote

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
View user's profile Send private message
apsar.kogatam
Warnings : 1

New User


Joined: 27 Jun 2008
Posts: 33
Location: CHENNAI

PostPosted: Thu Jan 28, 2010 1:00 pm
Reply with quote

Hi enrico,

All the unloaded datsets contains the data.I ran a single job with first mutigen steps and TABLE01---TABLE13.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Thu Jan 28, 2010 1:06 pm
Reply with quote

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
View user's profile Send private message
apsar.kogatam
Warnings : 1

New User


Joined: 27 Jun 2008
Posts: 33
Location: CHENNAI

PostPosted: Thu Jan 28, 2010 1:33 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Thu Jan 28, 2010 1:41 pm
Reply with quote

well it' s about time for Your support to take their lazy *** off the chair and start helping You. icon_biggrin.gif

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
View user's profile Send private message
apsar.kogatam
Warnings : 1

New User


Joined: 27 Jun 2008
Posts: 33
Location: CHENNAI

PostPosted: Thu Jan 28, 2010 1:47 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Thu Jan 28, 2010 1:51 pm
Reply with quote

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
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Thu Jan 28, 2010 1:56 pm
Reply with quote

Enrico,

maybe you start a chat session, having this 1-1 conversation.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Thu Jan 28, 2010 1:58 pm
Reply with quote

Hi Peter,
i' ll stop shortly, no reason to waste bandwidth icon_biggrin.gif
very little or better nothing can be done without having access to the faulty environment
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Thu Jan 28, 2010 2:02 pm
Reply with quote

Enrico,

i agree.
But i have never seen someone with this kind of patience.

And that for an Italian icon_rolleyes.gif
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India

PostPosted: Thu Jan 28, 2010 2:03 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Thu Jan 28, 2010 2:03 pm
Reply with quote

Thank You Peter!
Usually around here I am bashed for my bad manners !
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Thu Jan 28, 2010 2:05 pm
Reply with quote

Moderators getting bashed? I wouldnt dare.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Thu Jan 28, 2010 3:59 pm
Reply with quote

One simple thing that is easily overlooked is loading different tables within the same tablespace.

LOAD REPLACE empties the complete tablespace !
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts db2 vs static data COBOL Programming 1
No new posts combine multiple unique records into ... DFSORT/ICETOOL 2
No new posts Mark Previous & next lines when a... DFSORT/ICETOOL 9
No new posts External data queue (changes?) CLIST & REXX 0
No new posts Pull data using date difference betwe... DB2 6
Search our Forums:

Back to Top