MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

IMS DB problem during execution of Batch job (DLI)

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> IMS
View previous topic :: View next topic  
Author Message
gore
Beginner


Joined: 10 Dec 2002
Posts: 46
Topics: 20
Location: Providence, RI
PostPosted: Wed Sep 15, 2004 2:23 am    Post subject: IMS DB problem during execution of Batch job (DLI) Reply with quote
I am trying to execute a batch IMS program(DLI). The execution jcl looks like this:
Code:
//LBJ05004 EXEC PGM=DFSRRC00,REGION=2048K,             
 //         ACCT='RECON BILL EXTRACT PGM',             
 //         COND=((04,LT,LBJ05001),(04,GT,LBJ05002)),   
 //         PARM=(DLI,&LBP069,LBP069,,,,,,&LBP069M)     
 //STEPLIB  DD  DISP=SHR,DSN=&RESLIB                   
 //         DD  DISP=SHR,DSN=&LBP069L                   
 //         DD  DISP=SHR,DSN=&LINKLB1                   
 //         DD  DISP=SHR,DSN=&VSCOB2                   
 //DFSRESLB DD DSN=&RESLIB,DISP=SHR                     
 //DFSVSAMP DD DSN=&BUFFR69,DISP=SHR                   
 //DPKTABLE DD DSN=&DPKTAB,DISP=SHR                     
 //IMS      DD  DSN=&TDBDLIB,DISP=SHR                   
 //         DD  DSN=&DBDLIB,DISP=SHR     


The output of execution is not as expected. The output of this extract program is empty though it is not possible under any circumstances. The joblog shows following messages:

Code:
-JOBNAME  STEPNAME PROCSTEP    RC   EXCP   CONN    TCB   
-XGRSADUN STEP01   LBJ05003    00      8      4    .00   
+DFS035I BATCH INITIALIZATION COMPLETE  IMST             
DFS627I IMS RTM CLEANUP ( EOT ) COMPLETE FOR JS XGRSADUN -XGRSADUN STEP01   LBJ05004    00  52053  19753    .14   



Another IMS DB job that excuted successfully displays following messages in joblog(See below). The difference is remarkable. All intialiazation messages starting with BMS are missing all together in my log. The return code is zero. Can anyone tell me the potential problem and solution. I am also getting a IMS RTM CLEAN UP message.

-
Code:
JOBNAME  STEPNAME PROCSTEP    RC   EXCP   CONN    TCB    SRB  CLOCK   SERV
-XVISSUBS DELT01               08     14     16    .00    .00     .0    341
+DFS0578I - READ SUCCESSFUL FOR DDNAME PROCLIB  MEMBER = DFSMPLFP  IMST     
+DFS670I XVISSUBS.EXTRACT.STEP01 - MODULES HAVE BEEN PRE-LOADED  IMST       
+DFS035I BATCH INITIALIZATION COMPLETE  IMST                               
+BMC07734I DPK/IMS 2.5.00 $$DPICDS ALLOCATED DSN(IMS5.DATAPCKR.DPICDS) VOLS
+BMC07734I DPK/IMS 2.5.00 $$DPITBL ALLOCATED DSN(IMS5.DATAPCKR.DPITBL) VOLS
+BMC07738I DB(VFSSUB10) SEGMENT(VSSPCRR) INITIALIZATION COMPLETE  TECH(SH) +BMC07738I DB(VFSSUB10) SEGMENT(LSCAPS03) INITIALIZATION COMPLETE  TECH(SH)
+BMC07738I DB(VFSSUB10) SEGMENT(VSSPADR) INITIALIZATION COMPLETE  TECH(SH)
+BMC07738I DB(VFSSUB10) SEGMENT(VSSPNTE) INITIALIZATION COMPLETE  TECH(SH)


Another question: What is the function of DPKTABLE DD in IMSDLI execution JCL?
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
PostPosted: Wed Sep 15, 2004 6:08 am    Post subject: Reply with quote
gore,

From the sysout messages it is evident that you are using BMC software. Are you using the UNLOAD plus of IMS for unloading the data?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
gore
Beginner


Joined: 10 Dec 2002
Posts: 46
Topics: 20
Location: Providence, RI
PostPosted: Wed Sep 15, 2004 6:21 am    Post subject: Reply with quote
I am not using any utility, I am simply using a COBOL program to read IMS DB and then extract selected records to a flat file. Both the joblogs are from my shop. The only difference is that the successful job shows BMC messages and my unsuccessful job does not fetch anything and does not display BMC messages.
_________________
Gore
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
PostPosted: Wed Sep 15, 2004 8:27 am    Post subject: Reply with quote
Gore,

After some digging I found that the BMC messages you are seeing are a part of DATA PACKER/IMS which helps maximize your hardware investment, reduce time requirements for database maintenance, and improve application performance. By offering multiple compression options, DATA PACKER/IMS allows you to select the best compression method for your unique data. DATA PACKER/IMS provides both storage and performance benefits, achieving greater data compression and maintaining data integrity.

DPKTABLE is a tables data set which is required if your input database to the DPIDASD utility is compressed by DATA PACKER/IMS Version 1.3 using the exit DPKNCD.

Check this link for DATA PACKER/IMS Reference Manual


Check this link for DATA PACKER/IMS Messages Manual

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
gore
Beginner


Joined: 10 Dec 2002
Posts: 46
Topics: 20
Location: Providence, RI
PostPosted: Thu Sep 16, 2004 8:08 am    Post subject: Reply with quote
Thanks Kolusu!! I located the problem through xpeditor. When my program does not execute any IMS calls during run time i do not get those BMC messages, the logic was such that a parameter caused all the IMS calls to bypass.
Tha datapacker stuff was really useful.
_________________
Gore
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> IMS All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group