Text only | Text with Images

OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: lrfurtado on July 26, 2012, 02:03:40 PM

Title: problem reorganizing one of the system table arscab
Post by: lrfurtado on July 26, 2012, 02:03:40 PM
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.
Title: Re: problem reorganizing one of the system table arscab
Post by: Justin Derrick on July 27, 2012, 04:11:30 AM
It's a bug - DB2 needs a patch.

http://www-01.ibm.com/support/docview.wss?uid=swg1IC72083

-JD.
Text only | Text with Images