unable to load AFP file

[ASET]

I'm trying to load an AFP file with TLE's into OnDemand on Windows.  I'm getting the error message below:

C:\Program Files\IBM\OnDemand for Windows\bin>arsload -g baxterb -a baxterbApp -h ARCHIVE -u ODADMIN -p xxxxx -1 c:\temp\baxterapp.log -2 15 c:\arsload\bbb-plain.ARD
arsload: Processing file >c:\arsload\bbb-plain.ARD<arsload: Load Version <8.5.0.0> Operating System <Windows 64> <6.1.7601 ServicePack 1>
arsload: Server Version <8.5.0.0> Operating System <Windows 64> <6.1.7601 ServicePack 1> Database <DB2> <09.07.0000>
arsload: 08/04/12 16:08:20 -- Indexing started, 701200 bytes to process
0425-415 CC=YES
0425-415 CCTYPE=M
0425-415 CPGID=500
0425-415 FILEFORMAT=STREAM
0425-415 FORMDEF=F1ABBB
0425-415 RESOBJDD=RESDATA
0425-415 FDEFLIB=C:\data\res
0425-415 FONTLIB=C:\data\res
0425-415 PDEFLIB=C:\data\res
0425-415 OVLYLIB=C:\data\res
0425-415 PSEGLIB=C:\data\res
0425-415 RESOBJDD=RESDATA
0425-415 RESTYPE=all
0425-415 inputdd=c:\arsload\bbb-plain.ARD
0425-415 outputdd=.\bbb-plain.ARD.out
0425-415 indexdd=.\bbb-plain.ARD.ind
0425-415 resobjdd=.\bbb-plain.ARD.res
0425-440 ACIF AT PM06753 HAS COMPLETED NORMALLY WITH RETURN CODE 0.
arsload: 08/04/12 16:08:20 Indexing completed
arsload: 08/04/12 16:08:20 -- Loading started, 767791 bytes to process
Resource .\bbb-plain.ARD.res will be added as resource >2-1-0<.  Compression Type(OD77) Original Size(923771) Compressed Size(190973)
OnDemand Load Id = >5020-1-0-1FAA-0-0<
An error occurred.  Contact your system administrator and/or consult the System
Log.  File=arsadmp.c, Line=1573
Failed while attempting to load the database
Loaded 0 rows into the database
arsload: 08/04/12 16:08:21 Loading failed
arsload: Processing failed for file >c:\arsload\bbb-plain.ARD<
arsload: Unloading of data was NOT performed
arsload: Processing has stopped.  The remaining files will NOT be processed.

[pankaj.puranik]

Looking at the log, the failure happened while inserting the rows in the database.
Could you also post the message that you see in the System Log Folder.
That would be helpful.

Also make sure that you run the arsload with the -f parameter so that in case the loading fails, the partially loaded data is unloaded.
Otherwise you wouls end up having duplicates.

[ASET]

attached is my system log and the log defined in ARSLOAD.

DB2 was installed with ODADMIN, which is the same user as CMOD.  Still maybe a permissions issue with DB2.  Not sure how to test.

John

[ASET]

This is error is being logged in the system log

Unable to find SMS tablespace filesystems.  Either the defined SMS filesystems are full or there are no SMS filesystems defined.

[ASET]

Just like the error said I had to define a SMS filesystem.  The AFP file loads correctly.

[pankaj.puranik]

That's great !!