Author Topic: Loading error and runstat error  (Read 1375 times)

sylvain lareuze

  • Newbie
  • *
  • Posts: 9
    • View Profile
Loading error and runstat error
« 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


Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Loading error and runstat error
« Reply #1 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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

sylvain lareuze

  • Newbie
  • *
  • Posts: 9
    • View Profile
Re: Loading error and runstat error
« Reply #2 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