SQL error "-291" accessing table blah-blah...

[gwong]

Hello,

I was wondering if someone might have some insight into the following DB/2
CS problem...the following errors are occurring when accessing various
tables. The problem is causing the application (SAP R/3) to abend.

Database error text........: "SQLSTATE=55039 FUNCTION=SQLExtendedFetch
MSG=[IBM][CLI Driver][DB2/6000] SQL0291N State transition not allowed on
table
space. SQLSTATE=55039?"

I've attempted to identify the SQLSTATE and sql error codes in DB2
references but am unable to find any explanations. Does any one have an idea
about what the error message is referencing when mentioning 'state
transition not allowed on table', is the db attempting to alter some
attribute of the table? this seems a little strange because the error is
generated when looking up and writing values to a transaction table.

Thanks in advance to anyone who might be able to shed some light on the
above error message text.

Graham

--
Graham Wong
SAP/Technology Consultant
Soft Guide International
mailto:graha...@soft-guide.com
mailto:gw...@lycosmail.com

[Miro Flasza]

Graham,

Note that the message is indicating a problem with a tablespace,
not with any particular table. To closer examine the state of your
tablespaces you can use the "list tablespaces" DB2 command. Please
consult the manual regarding its output and possible options.

Regards,
Miro
--

---------------------------------------------
Miro Flasza
DB2 Universal Database Development
phone: (416)448-2405, e-mail: mi...@ca.ibm.com
---------------------------------------------

[Dash]

gwong <gw...@lycosmail.com> wrote:

: Database error text........: "SQLSTATE=55039 FUNCTION=SQLExtendedFetch

: MSG=[IBM][CLI Driver][DB2/6000] SQL0291N State transition not allowed on
: table
: space. SQLSTATE=55039?"

There might be more info in the db2diag.log about which tablespace is giving
this error meesage. I believe a certain invalid operation was requested
on a tablespace. Once you know which tablespace was involved (from the
db2diag.log) the other useful commands could be "list tablespaces", etc,
and of course DB2 service.