Library server not starting.

[pankaj.puranik]

Hi Guys

I have a CMOD installation on Windows server. This is used as a practice server (for R&D purposes).
Until a few days back the CMOD server was working fine.
But on my last login I realized that the Library server has stopped working.

I tried to start it using the OnDemand Configurator but it never starts.

On the Windows event log I see the following:

The description for Event ID ( 13 ) in Source ( OnDemand for WinNT ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [IBM][CLI Driver][DB2/NT] SQL0204N  "ODADMIN.ARSAG" is an undefined name.  SQLSTATE=42704  , 42S02, -204, arsag.c, 3949.

I see that DB2 is running properly.
However in the database i do not see any index tables or Application Group tables.
I am not sure if this problem is due to some database issue.
I feel that the OnDemand DB tables have been removed some how.

Let me know if you have any solution for this.

Cheers
Pankaj.

[Justin Derrick]

Hello. 

You are correct -- the error message states that the table 'arsag' (where the application group definitions are stored) is missing.

If you can't find any other tables (at the command line you could run "list tables for user" and "list table for all") then you'll need to recreate the library server database.  From the Windows Command Line, you should be able to run "arsdb - crtv" to create the database, tables, and indexes.

-JD.

[pankaj.puranik]

Hi Justin

It worked.
Thanks a lot!.