Print Page - Weird but true

Title: Weird but true
Post by: pankaj.puranik on April 16, 2015, 10:42:01 AM

Got thie weird message in CMOD.
The file loaded successfully with message code 87.
But the number of rows loaded into the database was 0.

The AFP TLEs look good. Any insights?

ARS1609W Specifying passwords on the command line is insecure due to the text being visible. See or information about the arsstash command or using Unified Login.
ARS4315I Processing file >DM34152_TEST_16_TLE.AFP<
ARS4334I Load Version <9.0.0.3> Operating System <Linux> <#1 SMP Fri Apr 11 17:27:00 EDT 2014.2. ation </opt/ibm/ondemand/V9.0/>
ARS4335I Server Version <9.0.0.3> Operating System <Linux> <#1 SMP Fri Apr 11 17:27:00 EDT 2014.
ARS4302I 04/16/15 05:52:01 -- Indexing started, 43070112 bytes to process
APK415I CC=YES
APK415I CCTYPE=A
APK415I CONVERT=YES
APK415I CPGID=500
APK415I IMAGEOUT=ASIS
APK415I RESTYPE=ALL
APK415I EXTENSIONS=RESORDER
APK415I INDEXOBJ=ALL
APK415I inputdd=/apps/IBM/cmod-poc/gb/MCA_LETTERS_OB82367_A001/download/afp/DM34
APK415I outputdd=./DM34152_TEST_16_TLE.AFP.out
APK415I indexdd=./DM34152_TEST_16_TLE.AFP.ind
APK415I resobjdd=./DM34152_TEST_16_TLE.AFP.res
APK440I ACIF AT IM43P11 HAS COMPLETED NORMALLY WITH RETURN CODE 0.
ARS4308I 04/16/15 05:52:07 Indexing completed
ARS4312I 04/16/15 05:52:07 -- Loading started, 435562 bytes to process
ARS1142I Resource ./DM34152_TEST_16_TLE.AFP.res will be added as resource >3-1-0
ARS1146I Loaded 0 rows into the database
ARS1175I Document compression type used - OD77Lite. Bytes Stored = >207< Rows =
ARS4310I 04/16/15 05:52:10 Loading completed
ARS4317I Processing successful for file >DM34152_TEST_16_TLE.AFP<

Title: Re: Weird but true
Post by: Ed_Arnold on April 16, 2015, 02:34:13 PM

Looks like you loaded a resource only? A resource but no data?

Ed

Title: Re: Weird but true
Post by: Justin Derrick on April 17, 2015, 10:26:35 AM

Yeah, something doesn't add up.

QuoteARS4302I 04/16/15 05:52:01 -- Indexing started, 43070112 bytes to process
ARS4312I 04/16/15 05:52:07 -- Loading started, 435562 bytes to process
ARS1175I Document compression type used - OD77Lite. Bytes Stored = >207< Rows =

I'm pretty sure there's a law of computer science that says you can't compress 43MB into 207 bytes. (Possible exception of storing the same character 43 million times.) :)

-JD.

Title: Re: Weird but true
Post by: Ed_Arnold on April 17, 2015, 03:22:18 PM

Just for fun, run the parts through arsafpd?

/usr/lpp/ars/V9R0M0/bin/arsafpd -d -i /foo

Ed

OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: pankaj.puranik on April 16, 2015, 10:42:01 AM