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 **********************************
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
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
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.
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
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.