Loading error and runstat error

[sylvain lareuze]

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

[Justin Derrick]

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.

[sylvain lareuze]

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