|
View previous topic :: View next topic
|
| Author |
Message |
Karthikeyan Subbarayan
New User
Joined: 24 Feb 2008
Posts: 62
Location: Boston
|
|
|
|
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) |
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 |
|
 |
Karthikeyan Subbarayan
New User
Joined: 24 Feb 2008
Posts: 62
Location: Boston
|
|
|
|
| Do my post is clear ? Do any one need more information on this ? |
|
| Back to top |
|
|
Karthikeyan Subbarayan
New User
Joined: 24 Feb 2008
Posts: 62
Location: Boston
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8700
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. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
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 |
|
|
Karthikeyan Subbarayan
New User
Joined: 24 Feb 2008
Posts: 62
Location: Boston
|
|
|
|
| Thanks all!!, the error happened because of unload file size is not matching. now it is working fine with MULTUSE = "YES". |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
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. |
|
| Back to top |
|
|
|
|
  |
All times are GMT + 6 Hours |
|
