Author Topic: problem reorganizing one of the system table arscab  (Read 2246 times)

lrfurtado

  • Guest
problem reorganizing one of the system table arscab
« on: July 26, 2012, 07:03:40 AM »
When we try reorging the arscab table on our installation we keep getting the following error when running the command bellow:

arsdb -mv arscab
Reorganizing table archive.arscab
Unable to reorganize table arscab.  SQLCODE = -2205
arsdb:  Unable to reorganize table archive.arscab

If I try to do the reorg or runstats directly on table using db2 CLP everything works.

We have 0 cabinets on our installation, but the problem is that if we ran the arsdb -mv without specifying the system tables we get a error on arscab table.

Any advice would be appreciated.

thanks.

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2231
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: problem reorganizing one of the system table arscab
« Reply #1 on: July 26, 2012, 09:11:30 PM »
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