OnDemand User Group

Support Forums => MP Server => Topic started by: sylvain lareuze on December 02, 2020, 12:02:59 AM

Title: Loading error and runstat error
Post by: sylvain lareuze on December 02, 2020, 12:02:59 AM

Hi,

we use CMOD V10.1.0.4 on AIX 7.2 with DB2 11.1.0.404.

we have load in error with no explanation in the System Log message 88. But before the Message 88 we have :

    13   DB Error: RUNSTATS ON TABLE cmodqua1.BIB5 -- SQLSTATE=Not Defined, SQLCODE=1, File=arssys.c, Line=1895

we try to execute arsdb -I CMODQUA1 -mvs and we have this message :
ARS4040I Reorganizing table cmodqua1.arsag
ARS4042I Updating runstat statistics for table cmodqua1.arsag
ARS4090E Unable to do a runstats on table cmodqua1.arsag.  err=1
ARS4043E Unable to update runstat statistics on table cmodqua1.arsag

Could you help me for this problem, I think the loading in error follow the Runstat in error?

thanks

Sylvain

Title: Re: Loading error and runstat error
Post by: Justin Derrick on December 02, 2020, 08:04:21 AM

You'll want to have your DB2 database administrator investigate the cause to make sure it isn't something serious.  In the past, I've solved this problem by taking CMOD & DB2 offline, running a DB2 full offline backup, then running a re-org on all of the ARS* tables and whichever Application Group tables that were causing problems.

Good luck, and please reply back with the solution when you find it!

-JD.

Title: Re: Loading error and runstat error
Post by: sylvain lareuze on December 02, 2020, 11:54:15 PM

Hi Justin,

Thanks for your help.

I backup the database offline and check the file all  is OK.
I try to restart CMOD and the arsload crash.
So I check the ARS_TMP it was full, I dump all the old file from the ARS_TMP and now all works.

Thanks

Sylvain