Messages

1726

MP Server / Re: AIX fp4 upgrade to 8.5.0 arsdb fails to initialize

« on: April 05, 2012, 05:25:38 AM »

Hi Walt.

Two things...

I've always used arsdb -gkv as my command to start the database, and leave it 'activated', that is, ready for connections.  Maybe try adding the k to your command.

For more diagnostic information, run this command as root:
swcons `tty`
(Those are backticks, not quotes - it's to the left of my '1' key on my keyboard.)
Then try running arsdb -gkv again -- this time, any diagnostic output will be directed to your screen.  Show us that output and we might be able to help.

-JD.

1727

MP Server / Re: ARS_ORIGINAL_CODEPAGE going from 8.4 to 8.5

« on: March 28, 2012, 04:46:29 AM »

arsdb: Unable to load >DB2<

Looks like you upgraded DB2 but didn't run 'db2ln' to create links to the new DB2 libraries.

-JD.

1728

MP Server / Re: ARS_ORIGINAL_CODEPAGE going from 8.4 to 8.5

« on: March 27, 2012, 12:33:04 PM »

It's in the ReadMe for 8.5:

 4.1   New ars.cfg parameter ARS_ORIGINAL_CODEPAGE
        A new ars.cfg parameter, ARS_ORIGINAL_CODEPAGE, is now required.
        When using OnDemand for MP V8.5 to access a pre-V8.5 OnDemand instance,
        this MUST be set to the codepage the pre-V8.5 OnDemand server was
        running in.  Failure to set it will prevent the OnDemand server from
        starting.  Setting it incorrectly will result in data corruption.

        Example failure to start message which will be sent to the console:
         DB Error: STARTUP -- SQLSTATE=1.  ARS_ORIGINAL_CODEPAGE is not
                   defined in ars.cfg.  Run arsdb -u -I <OD_INSTANCE> to
                   determine setting of ARS_ORIGINAL_CODEPAGE, SQLCODE=0,
                   File=arssrvr.c, Line=7892

4.2   Steps to set the value of ARS_ORIGINAL_CODEPAGE
  4.2.1   UNIX Servers
        Run arsdb -u without ARS_ORIGINAL_CODEPAGE in the ars.cfg for
        information on the proper setting for ARS_ORIGINAL_CODEPAGE.

        An example of running the arsdb -u -I <OD_INSTANCE> command without
        ARS_ORIGINAL_CODEPAGE in the ars.cfg is:
          arsdb:  Unable to initialize environment. The return code is -1.  If
                  this is a new (created in 8.5) instance, then define
                  ARS_ORIGINAL_CODEPAGE=819 in ars.cfg.  Otherwise, if this is
                  an existing instance (created prior to 8.5), then define
                  ARS_ORIGINAL_CODEPAGE=923 in ars.cfg.  Once set,
                  ARS_ORIGINAL_CODEPAGE must never change.

1729

Report Indexing / Re: Ingesting an XML document into OnDemand

« on: March 16, 2012, 09:33:41 AM »

The short answer is that you must write a program to create the Generic Index file (possibly based on the contents of the XML file itself) for arsload to process.

You can write this program in any language, but a language optimized for text processing (like Perl, especially with XML modules) will be your best choice.

Once your program is complete, and produces the generic index files for arsload, you need to create an Application with a 'User Defined' type, and ensure that your users have the ability to view XML files on their PCs.

-JD.

1730

OD/WEK & JAVA API / Re: Error ODWEK CGI 8.5

« on: March 15, 2012, 06:52:05 AM »

That's a very common web server error message.

It sounds like your program doesn't have permissions (either from the operating system or web server software) to be executed.

-JD.

1731

z/OS Server / Re: Upgrade 8.3 to 8.4.0: No documents meet the search criteria

« on: March 14, 2012, 07:29:36 AM »

That's strange.  I know you're on a mainframe, but are their any 'console messages' from arssockd?  In the multiplatforms world, arssockd writes diagnostic messages to the console (/dev/console) which can be read with dmesg (on Linux), or switched to be the local console by using the swcons command (on AIX).

I'd also check DB2 for diagnostic info.

1732

MP Server / Re: ARSLOAD says could not connect to server, which one?

« on: March 14, 2012, 07:09:21 AM »

Hi.

Just wanted to let you know that I've edited your post to remove the UID & Password that was displayed in clear text.

To answer your question, I'm under the impression that arsload requires the -h parameter.  To load to the local instance of CMOD, I regularly use "-h localhost".  (The name localhost is defined in the TCP/IP specifications, and resolves to 127.0.0.1 -- which is always the system itself, for anyone who's curious.)

Give that a try and let us know if anything has changed.

-JD.

1733

Report Indexing / Re: Can you recommend a tool for creating AFP Resources, like FormDefs?

« on: February 28, 2012, 07:02:26 AM »

Thanks for the reply.  I also posted this question on LinkedIn -- here's a link to that thread:
   http://www.linkedin.com/groups/What-software-utilities-Win-Linux-4148818%2ES%2E91388441

In summary, here are the products I found:

• Elixir's DesignPro Tools AFP
• ISIS Papyrus Designer
• Ricoh (formerly IBM Printing Systems) PPFA
• HP Exstream Dialogue

I'll add others to this list as I discover them.

1734

Other / Re: ARSADMIN vs ARSMAINT

« on: February 17, 2012, 08:34:02 AM »

Nope, CMOD distributes loaded files across cache filesystems -- so your Application Groups are intermixed between both, and that's perfectly fine.

-JD.

1735

Other / Re: ARSADMIN vs ARSMAINT

« on: February 16, 2012, 04:49:15 AM »

You shouldn't need to tweak it - depending on your expiration type, arsmaint should clean up the objects as well as the rows in the database table.  My understanding is that the expiration type of 'segment' doesn't issue an explicit delete of objects (in cache or TSM), but from your description, it doesn't sound like your expiration type is segment.

1736

Report Indexing / Re: Trigger1 Using ASCII Carriage Control

« on: February 16, 2012, 04:39:13 AM »

The only other thing I've seen regularly is that cover pages prevent 'indexstartby' from working properly.  Increase this to 2 or 3 if you have cover pages before your report.

Otherwise, I think I'd need to see some sample data.

-JD.

1737

MP Server / Re: Load AFP Full Composed failed, error about resource

« on: February 14, 2012, 07:43:05 AM »

Wow.  That's mangled.

Are you sure you transferred the file in 'binary' format?  Which file transfer method are you using?  Are you able to transfer the file to a PC and view it with AFPViewer?

-JD.

1738

Report Indexing / Re: Trigger1 Using ASCII Carriage Control

« on: February 14, 2012, 07:40:26 AM »

A quick look at your indexing parameters shows that you're using the same character for newlines as you're searching for in column 1:

FILEFORMAT=STREAM,(NEWLINE=X'0A')
TRIGGER1=*,1,X'0A',(TYPE=GROUP)

I think you'll want to change the character you're looking for in TRIGGER1.

-JD.

1739

MP Server / Re: How configuring multiple objects server with single library server

« on: February 14, 2012, 07:36:52 AM »

The only difference between installing a Library and Object server is the database component.  So, to install a CMOD Object Server, simply skip the steps involving the (DB2/Oracle/MS-SQL) database.  In terms of configuration, you'll need to change ars.cfg to configure the server as ab Object Server.

Having said that...  There are very, very few situations in which managing separate object and library servers makes sense anymore.  Initially, the rationale for separate library and object servers was to distribute the work of loading files back when CPUs ran around 100Mhz, and to reduce cost and latency when network bandwidth between branch offices was both slow AND prohibitively expensive.  Now, those issues only exist for the very largest of systems (with petabytes of data and hundreds of thousands of users).

Is there a specific reason why you want to go with separate Object and Library servers?

-JD.

1740

Report Indexing / Re: Intermittent Index and Load Failures arsadmin.c

« on: February 09, 2012, 08:48:24 AM »

As usual, Alessandro is right.  You need to increase the amount of RAM allocated to the CMOD 'applications' that connect to DB.

Since you're (severely) backleveled on DB2, the parameter you want to check for is APPLHEAPSZ.

To update this parameter in DB2, use this command:
    db2 update db cfg for archive using applheapsz <new size in pages>

Your friendly neighbourhood DBA should be able to recommend a value based on the rest of your DB2 configuration.  In the (distant) past, I've set this value to 1024 (in combination with other changes to other parameters like DBHEAP) to resolve similar issues with failed queries.  Of course, always make a note of your current values so you can go back to them if the change doesn't have the desired effect.

-JD.