Page 1 of 1

Generate DB2 Load Card

PostPosted: Mon Oct 19, 2015 5:23 pm
by Prasanna G
Hi

I am trying to create a Load card while doing BMC Unload of my table. I am using the below unload card.
//SYSIN DD *                                             
     UNLOAD                                               
     FORMAT CSV TERMINATEDBY ';' ENCLOSEDBY ''           
     NULLSTRING ''                                       
     UNICODE                                             
     TSFMT('YYYY-MM-DD HH:MM:SS.NNNNNN')                 
     UNLOADDN SYSREC ACTIVE NO                           
     SHRLEVEL CHANGE                                     
     SORTDEVT SYSDA                                       
     SORTNUM 4                                           
     SELECT *,X'0A'                                       
     FROM WCC12.XLOCATIONPREF;                           
//SYSREC DD DSN=MBTT.UNLOAD.XLOCPREF.TAPE.WCC12.OCT05,   
//         UNIT=CARTG00,VOL=(,,,10),                     
//         DISP=(NEW,CATLG,DELETE)                       
//*                                                       
//SYSCNTL DD DSN=MBTT.UNLOAD.XLOCPREF.CNTL.WCC12.OCT05,   
//         DISP=(NEW,CATLG,CATLG),                       
//         SPACE=(TRK,(1,1),RLSE),                       
//         UNIT=SYSDA                                     


But the control card data set is created with Invalid block size and I am not able to use the same for load purpose. Can someone please let me know how to create a load card to load data back to DB2 using BMC?

Thanks
Prasanna G.

Re: Generate DB2 Load Card

PostPosted: Mon Oct 19, 2015 5:58 pm
by NicC
You appear to have an instream control card so that will default to 80 bytes LRECL but I don't know the blksize without looking up the manuals. Are you sure that it is the SYSIN that is being complained about? How about posting the error message.
Why not create a dataset with correct attributes and put your control cards in there?

Re: Generate DB2 Load Card

PostPosted: Mon Oct 19, 2015 6:07 pm
by Prasanna G
Hi NicC,

I tried to remove the TSFMT from my unload card and ran the unload job. The SYSCNTL card is now getting created.

Thanks
Prasanna G.