Topic
  • 1 reply
  • Latest Post - ‏2011-03-22T12:47:51Z by HeWeCo
Blitz60
Blitz60
2 Posts

Pinned topic Why do I get SQLCODE -804?

‏2011-02-24T19:06:37Z |
A customer is using Optim Version 5.5.3 und DB2 V9.1
If he tries to browse SYSIBM.SYSTABLESPACESTATS he gets an
SQLCODE-804 Reason 16.
We tried the same with a lot of other tables - each of them works.
The Optim directory has been successfully updated and therefore it supports long tablespace names.
Any idea?
TIA and best regards,

Blitz60
Updated on 2011-03-22T12:47:51Z at 2011-03-22T12:47:51Z by HeWeCo
  • HeWeCo
    HeWeCo
    2 Posts

    Re: Why do I get SQLCODE -804?

    ‏2011-03-22T12:47:51Z  
    Hi Blitz60,
    the sqlcode of -804 is caused by an xml or a blob column in the table within this tablespace.
    Older Optim versions do not support xml. IBM offers some custom fixes that handle this problem. But it would be much better to upgrade to a new optim release. Currently I do some tests with Optim 7.1 and it works quite fine.
    Regards
    HeWeCo