Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Load Datacom using DBUTLTY

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
Karthikeyan Subbarayan

New User


Joined: 24 Feb 2008
Posts: 56
Location: Boston

PostPosted: Tue May 14, 2013 1:14 am    Post subject: Load Datacom using DBUTLTY
Reply with quote

Hi,
I am trying to load the DATACOM table using DBUTLTY. The control card information is specified as below


Code:
LOAD                                                     
  AREA=GI2,TABLE=GI2,DBID=555,DDNAME=DATAIN,OPTIMIZE=YES,
  KBYTES=300,MULTUSE=YES,FORMAT=EXTRACT 


Now i am getting error for MULTUSE parameter as below

Code:

                    FUNCTION=LOAD                                             
                       AREA=GI2                                               
                       DBID=00555                                             
                       DDNAME=DATAIN                                           
                       FORMAT=EXTRACT                                         
                       KBYTES=0300                                             
*****- ERROR -*****    MULTUSE=YES  DB10047E - NOT ALLOWED BECAUSE - SORT=     
                       OPTIMIZE=YES                                           
                       TABLE=GI2                                               
                                                                               
DB10015E - NO EXECUTION DUE TO INDICATED ERROR(S)                             

Quote:


I also tried giving MULTUSE as "NO" then i am getting error as below


Code:
DB13018E - OPEN ERROR, RETURN CODE 46 (46) BASE OPEN IN ANOTHER COPY OF DATACOM
DB10045E - ABNORMAL TERMINATION DUE TO ERROR(S)                               
******************************** END OF DATA **********************************


Please let me know how to proceed further
Back to top
View user's profile Send private message

Karthikeyan Subbarayan

New User


Joined: 24 Feb 2008
Posts: 56
Location: Boston

PostPosted: Tue May 14, 2013 1:38 am    Post subject: Reply to: Load Datacom using DBUTLTY
Reply with quote

Do my post is clear ? Do any one need more information on this ?
Back to top
View user's profile Send private message
Karthikeyan Subbarayan

New User


Joined: 24 Feb 2008
Posts: 56
Location: Boston

PostPosted: Tue May 14, 2013 2:36 am    Post subject: Reply to: Load Datacom using DBUTLTY
Reply with quote

I think the SORT parm is mandatory when MULTUSE is "YES", So i tried giving th SORT parm also now i am getting S013 Abend.

Control card looks like :
Code:
***************************** Top of Data *****************************
 LOAD                                                                 
   AREA=GI2,TABLE=GI2,DBID=555,DDNAME=DATAIN,SORT=999999,OPTIMIZE=YES,
   KBYTES=300,MULTUSE=YES,FORMAT=EXTRACT                               
**************************** Bottom of Data ***************************


The Error looks like below :

Code:
IRR010I  USERID OXT$     IS ASSIGNED TO THIS JOB.                               
ICH70001I OXT$     LAST ACCESS AT 15:41:17 ON MONDAY, MAY 13, 2013             
$HASP373 YVM5001Q STARTED - INIT 263  - CLASS U - SYS ESYS                     
IEF403I YVM5001Q - STARTED - TIME=15.41.26                                     
DB00101I - STARTED JOB-YVM5001Q NUMBER-69211 CXX=DBITDU4V                       
DBITDU4V:DB00101I - STARTED JOB-YVM5001Q NUMBER-69160 CXX=DBITDU4V MUFNAME=DBITD
IEC141I 013-20,IGG0191A,YVM5001Q,DBUTIL,DATAIN,9466,NU4005,YVMT.EXN.GIB.U4V.UNLO
IEA995I SYMPTOM DUMP OUTPUT  213                                               
SYSTEM COMPLETION CODE=013  REASON CODE=00000020                               
 TIME=15.41.27  SEQ=05053  CPU=0000  ASID=00C0                                 
 PSW AT TIME OF ERROR  075C1000   80DD1C2A  ILC 2  INTC 0D                     
   NO ACTIVE MODULE FOUND                                                       
   NAME=UNKNOWN                                                                 
   DATA AT PSW  00DD1C24 - 4100302C  0A0D010D  A7E50126                   


Please let me know if you have any suggestions
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7904
Location: Bellevue, IA

PostPosted: Tue May 14, 2013 3:00 am    Post subject:
Reply with quote

An 013-20, from the MAC manual:
Quote:
20 An OPEN macro instruction was issued for a sequential data set using queued access. BLKSIZE is not a multiple of LRECL, or LRECL is 0 with RECFM=FB or RECFM=FBS, or BLKSIZE is not at least four bytes greater than LRECL with RECFM=V.
So your original unload might be bad, or you need to specify JCL parameters you haven't yet specified, or you may need to contact the vendor to resolve the issue.

Also, responding on this forum is voluntary and happens when / if people have time to post and know something about the topic. Posting something like
Quote:
Do my post is clear ? Do any one need more information on this ?
less than half an hour after your original post is NOT the way to get responses -- it is MUCH more likely to cause people to decide not to respond to your post.

Plus, you posted a Datacom question in the IBM Tools forum. Datacom is a product from CA, not IBM.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue May 14, 2013 7:46 pm    Post subject:
Reply with quote

Hello,

Your topic has been relocated to the CA part of the forum,

The 46 is because your load cannot run while any URT is open that uses that database.

You should close the online URT(s) that reference that base/table and make sure no other batch job is running that uses same.
Back to top
View user's profile Send private message
Karthikeyan Subbarayan

New User


Joined: 24 Feb 2008
Posts: 56
Location: Boston

PostPosted: Wed May 15, 2013 9:46 am    Post subject: Reply to: Load Datacom using DBUTLTY
Reply with quote

Thanks all!!, the error happened because of unload file size is not matching. now it is working fine with MULTUSE = "YES".
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed May 15, 2013 7:43 pm    Post subject:
Reply with quote

Hello,

Quote:
error happened because of unload file size is not matching
Yes, the 013-20 says there is a problem at open time with incompatible DCBs.

Quote:
now it is working fine with MULTUSE = "YES".
Well, it is running anyway. . . It you run with MULTUSE=YES, your unloaded data may be inconsistent. If the unload runs while processes are inserting, changing, or deleting rows, the data in the unload file can be unpredictable. It just depends on how clean the unloaded data must be. fwiw.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Copybook structure in Load module Vai123 COBOL Programming 7 Fri Sep 16, 2016 8:29 pm
This topic is locked: you cannot edit posts or make replies. ERROR WHILE SUBMITTING LOAD JOB ANURADHA NEELAKANTAN JCL & VSAM 12 Thu Aug 25, 2016 11:50 am
No new posts Execute multiple DB2 Load commands in... faizm DB2 4 Wed Aug 03, 2016 12:53 pm
No new posts Search a Load Module sreekanth1984 TSO/ISPF 8 Tue Jun 07, 2016 8:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us