Messages

376

MP Server / Re: arsload - TSM issue

« on: February 23, 2018, 12:56:21 PM »

Hi niteskum,

                      We are using TSM version 7.1.1 and cmod v 9.5 and db2 10.1 and when am trying to load the document the following error is occurring  even we checked the system logs but there is nop any information:  the tsm server is running fine  and connected to database

ARS4315I Processing file >C:\com\chytu.txt<
 ARS4334I Load Version <9.5.0.0>  Operating System <Windows 64> <6.2.9200.16384>  OS Userid <ADMIN>  Install Location <C:\PROGRA~1\IBM\OnDemand\V9.5\>
 ARS4335I Server Version <9.5.0.0>  Operating System <Windows 64> <6.2.9200.16384>  Database <DB2> <10.05.0003>
 ARS4339I Application Group >tsmtest1<
 ARS4340I Application >tsmtest1<
 ARS4341I Storage Set >CMODTSM<
 ARS4342I Storage Node >NODE1<
 ARS4302I Indexing started, 2939 bytes to process
 APK415I CC=NO
 APK415I CCTYPE=Z
 APK415I CONVERT=NO
 APK415I CPGID=850
 APK415I MCF2REF=CPCS
 APK415I TRC=NO
 APK415I FILEFORMAT=STREAM,(NEWLINE=X'0D0A')
 APK415I TRIGGER1=*,1,X'4163636F756E74204E616D65',(TYPE=GROUP)
 APK415I FIELD1=0,24,9,(TRIGGER=1,BASE=0)
 APK415I INDEX1=X'666E616D65',FIELD1,(TYPE=GROUP,BREAK=YES)
 APK415I DCFPAGENAMES=NO
 APK415I UNIQUEBNGS=YES
 APK415I IMAGEOUT=ASIS
 APK415I INDEXOBJ=GROUP
 APK415I INDEXSTARTBY=1
 APK415I INSERTIMM=NO
 APK415I RESTYPE=NONE
 APK415I INPUTDD=C:\com\chytu.txt
 APK415I OUTPUTDD=NUL
 APK415I INDEXDD=C:\PROGRA~1\IBM\OnDemand\V9.5\bin\chytu.txt.ind
 APK415I RESOBJDD=NUL
 APK440I ACIF AT IPTR914 HAS COMPLETED NORMALLY WITH RETURN CODE 0.
 ARS4308I Indexing completed
 ARS4312I Loading started, 2939 bytes to process
 ARS1144I OnDemand Load Id = >5026-2-0-1FAA-0-0-5027<
 ARS1107E An error occurred.  Contact your system administrator and/or consult the System Log.  File=arsload.c, Line=6166
 ARS1157E Unable to store the object >1FAAA<.  Object size 1179
 ARS1146I Loaded 0 rows into the database
 ARS4311E Loading failed
 ARS4319W Unloading of data was NOT performed
 ARS4318E Processing failed for file >C:\com\chytu.txt<

Looks like a storage issue. Go into the system log and look for logID's with "error" and see what you can find. It should point you to something TSM related

377

MP Server / Re: CMOD 8.5 + TSM

« on: February 16, 2018, 07:52:35 AM »

TSM 6.1 marked the transition to DB2 as the internal database, and the migrations were horrendous.  I'm still doing them today, because people were so resistant to move up to TSM 6.x.

This is where I was going. Typo referring to TSM 8.5 included with CMOD 8.5, meant 5.5.

378

MP Server / Large Migration + Codepage

« on: February 15, 2018, 08:57:22 AM »

I am going to be migrating a system from 8.5 AIX to 10.1 Linux over the next few weeks...both DB2..our 8.5 uses TSM, and the 10.1 storage set is probably going to be cloud object storage.

I stood up the V10.1 environment with the proper codepage (1208 per the documentation). We are using 923 in 8.5..I am wondering if we can still migrate due to the differences in codepage

When I say migrate, I mean do a db2move, move over all tables, TSM, etc. Also, if our old version of TSM will give us issues..which I have a feeling it might.

Would a retrieve/load be easier?

379

MP Server / Re: After CMOD Fix packe Upgraded what are the arsdb command should run

« on: February 05, 2018, 11:04:29 AM »

I did this in my tech environment and saw no issuees.

./file.bin -i console

Ran fine..

What kind of file/indexing are you using?

380

MP Server / 65/226 Message logging -- excessive

« on: February 01, 2018, 11:49:12 AM »

Hi all,

I was part of a major issue a few years ago on 8.4 where we had 65 and 226 messages turned on for every app group in production. It caused slowness and crazy instability. I believe there was a tech note for this, or it may have been a PMR we opened.

does anyone have more information on this? We are logging 100k+ a day

381

MP Server / CMOD 8.5 + TSM

« on: January 23, 2018, 06:56:57 AM »

Does anyone remember what version of TSM was included with 8.5? I think it was 8.5, but i could be wrong.

Anyone remember?

382

Content Navigator / Re: AFP2PDF Transform Not Working with ICN 3.0.1

« on: January 09, 2018, 12:38:02 PM »

In other words, set up a scheduler so it runs continually.

Can you shed some light on this?

383

MP Server / Re: return date field as mm/dd/yy

« on: January 05, 2018, 07:04:20 AM »

yeah i played around with this for a few minutes last night and couldnt get it to work. Will have to mess with more today.

384

MP Server / return date field as mm/dd/yy

« on: January 04, 2018, 01:08:19 PM »

Hi All, I have the most simple sql query ever I am writing to a file

select policy, rdate from ada1

as expected, rdate is being returned in the 5 digit date format. Is there any SIMPLE way to do this on the fly, that doesnt require me from writing a stored procedure

What I have:

db2 => select policy, rdate from ada1

POLICY                                             RDATE
-------------------------------------------------- ------
3741474                                            17479

What I want:

What I have:

db2 => select policy, rdate from ada1

POLICY                                             RDATE
-------------------------------------------------- ------
3741474                                            11/08/17

Thanks

385

Report Indexing / Re: Exit not found

« on: January 02, 2018, 07:32:09 AM »

Wonderful. Made changes, but-

From the 88 message-

APK425S USER INDEX EXIT /exits/indexexnf WAS NOT FOUND.

From ars.cfg-

admin@server [09:30:20] ~/ ->more /opt/ibm/ondemand/V10.1/config/ars.cfg | grep EXIT
ARS_USER_EXITS_DIR=/exits

From app settings-

INDXEXIT=/exits/indexexnf

386

Report Indexing / Re: Exit not found

« on: December 30, 2017, 11:39:52 AM »

Yea, same thing

APK415I INDXEXIT=indexexnf
APK425S USER INDEX EXIT indexexnf WAS NOT FOUND.
APK441I ACIF AT PI72113 HAS COMPLETED ABNORMALLY WITH RETURN CODE 16.

jsquier@if21t54od [01:39:05] /opt/ibm/ondemand/V10.1/bin/exits/ ->ls -latr
total 20312
-r--r--r--. 1 root root    6008 Mar 21  2017 arsfterm
-r-xr-xr-x. 1 root root 4341048 Aug  8 16:27 arssmtsm
-r-xr-xr-x. 1 root root 4776344 Aug  8 16:27 arsorcle
-r-xr-xr-x. 1 root root 4772312 Aug  8 16:27 arsdb2
-r-xr-xr-x. 1 root root 6869104 Aug  8 16:27 arscmn64
-rwxrwxrwx. 1 root root   12342 Dec 20 13:19 indexexnf


ARS_USER_EXITS_DIR=/opt/ibm/ondemand/V10.1/bin/exits/


Any thoughts? Wishing you the best in 2018

387

Report Indexing / Re: Exit not found

« on: December 29, 2017, 08:22:12 AM »

Doesnt like it for some reason

ARS_USER_EXITS_DIR=/tmp
-rwxrwxrwx.  1 root    root        8816 Dec 29 10:19 indexexnf

From my app setting-

INDXEXIT=indexexnf

Any more suggestions before i bug IBM?

388

General / Re: ARSLOAD Remotely

« on: December 29, 2017, 07:25:52 AM »

install CMOD, dont configure, point ARSLOAD to the right host, should work pretty easily.

389

Report Indexing / Exit not found

« on: December 28, 2017, 12:47:18 PM »

I am working with the imexit.c, which is included in cmod.

Started off by doing gcc indexexnf imexit.c to compile. Then I send a file through. Without the exit being referenced in the index params, it works fine.

  : APK415I INDEX16=X'C4D3C2C1D9',FIELD16,(TYPE=GROUP,BREAK=YES)
                          : APK415I DCFPAGENAMES=NO
                          : APK415I UNIQUEBNGS=YES
                          : APK415I IMAGEOUT=ASIS
                          : APK415I INDEXOBJ=ALL
                          : APK415I INDEXSTARTBY=1
                          : APK415I INSERTIMM=NO
                          : APK415I RESTYPE=ALL
                          : APK415I CHARS=GT15
                          : APK415I FDEFLIB=/home/archive/reslib/
                          : APK415I PDEFLIB=/home/archive/reslib/
                          : APK415I PSEGLIB=/home/archive/reslib/
                          : APK415I FONTLIB=/home/archive/reslib/
                          : APK415I OVLYLIB=/home/archive/reslib/
                          : APK415I INDXEXIT=/opt/ibm/ondemand/V10.1/exits/acif/indexexnf
                          : APK415I INPUTDD=/home/jsquier/SY91.CCM40D1.APP.AG.20171009.101654.ARD
                          : APK415I OUTPUTDD=/home/jsquier/SY91.CCM40D1.APP.AG.20171009.101654.ARD.out
                          : APK415I INDEXDD=/home/jsquier/SY91.CCM40D1.APP.AG.20171009.101654.ARD.ind
                          : APK415I RESOBJDD=/home/jsquier/SY91.CCM40D1.APP.AG.20171009.101654.ARD.res
                          : APK425S USER INDEX EXIT /opt/ibm/ondemand/V10.1/exits/acif/indexexnf WAS NOT FOUND.
                          : APK441I ACIF AT PI72113 HAS COMPLETED ABNORMALLY WITH RETURN CODE 16.
2017-12-28 14:33:20.403303: ARS4309E Indexing failed

But..

jsquier@server [02:33:33] /opt/ibm/ondemand/V10.1/exits/acif/ ->ls -l | grep indexexnf
-rwxrwxrwx. 1 root root   8816 Dec 28 14:22 indexexnf

any ideas?

390

MP Server / Re: APK346W PAGEDEF RESOURCE IS INVALID Error on Line File

« on: December 14, 2017, 08:25:23 AM »

Can you try a different trigger.