arsload - ars1159e unable to retrieve the object >27<

[SV]

Hello Group

I ran a test for remote load from AIX to Z/OS.  (past the ars.ini config issue  )

Here is arsload log from my first attempt, where object 27 failed load

ARS4315I Processing file >SBBY<
ARS4334I Load Version <9.0.0.3>  Operating System <AIX> <6.1>  OS Userid <aixuser>  Install Location </opt/IBM/ondemand/V9.0/>
ARS4335I Server Version <9.0.0.3>  Operating System <z/OS> <04.24.00>  Database <DB2> <10.01.0005>
ARS4312I 06/12/15 14:29:18 -- Loading started, 1285193 bytes to process
ARS1142I Resource SBBY.res will be added as resource >27-2-0<.  Compression Type(OD77) Original Size(21784981) Compressed Size(5410223)
ARS1142I Resource /tmp/l390.7143594.1.1434137361.726.res will be added as resource >27-2-0<.  Compression Type() Original Size(0) Compressed Size(5410223)
ARS1107E An error occurred.  Contact your system administrator and/or consult the System Log.  File=arsadmp.c, Line=1463
ARS1157E Unable to store the object >27<.  Object size 0
ARS1146I Loaded 0 rows into the database
ARS4311E 06/12/15 14:29:22 Loading failed
ARS4318E Processing failed for file >SBBY<


Here is arsload log from second attempt,
ARS4334I Load Version <9.0.0.3>  Operating System <AIX> <6.1>  OS Userid <AIXUSER>  Install Location </opt/IBM/ondemand/V9.0/>
ARS4335I Server Version <9.0.0.3>  Operating System <z/OS> <04.24.00>  Database <DB2> <10.01.0005>
ARS4312I 06/12/15 14:39:16 -- Loading started, 1285193 bytes to process
ARS1107E An error occurred.  Contact your system administrator and/or consult the System Log.  File=arsadmp.c, Line=6895
ARS1159E Unable to retrieve the object >27<
ARS4311E 06/12/15 14:39:18 Loading failed
ARS4318E Processing failed for file >SBBY<
Processing has stopped.  The remaining files will NOT be processed.

question
 1) In a remote load where does it write the temporary index file, on local server or on remote server? First load could have failed due to permission issue on the /tmp folder
  2) how to get rid of the resource object entry 27 so i could retry my load with correct permissions to the /tmp directory?

thanks
SV

[Ed_Arnold]

You'd better open a PMR.

Sounds like you have a couple tables out of sync.

The first error - you'll have to figure out why the resource object didn't get written out.

The second error, sounds like an entry was made in a table even though a resource object wasn't stored.

Ed

[Michael Prouse]

PI29809: ARSLOAD FAILS WITH UNABLE TO RETRIEVE THE OBJECT

http://www-01.ibm.com/support/docview.wss?uid=swg1PI29809

[Ed_Arnold]

Michael - thank you for posting the solution.

Ed