Urgent SQL0293N

[Sintesi]

I got the SQL0293N error. someone can help me to solve this problem? My
db2 is version 7.1 on win2000 server.

[Serge Rielau]

Sintesi wrote:
> I got the SQL0293N error. someone can help me to solve this problem? My
> db2 is version 7.1 on win2000 server.
>

Did you follow the error message instructions?

SQL0293N Error accessing a table space container.

Explanation:

This error may be caused by one of the following conditions:

o A container (directory, file or raw device) was not found.

o A container is not tagged as being owned by the proper table
space.

o A container tag is corrupt.

This error can be returned during database startup and during
the processing of the ALTER TABLESPACE SQL statement.

User Response:

Try the following actions:

1. Check that the directory, file, or device exists and that the
file system is mounted (if it is on a separate file
system). Containers must be readable and writable by the
database instance owner.

2. If you have a recent backup, try restoring the table space or
database. If that fails because of the bad container and the
container is not a DEVICE type, try manually removing the
container first.

If the error was returned from the processing of an ALTER
TABLESPACE SQL statement with the SWITCH ONLINE option, then
re-issue the statement after correcting the problem as described
above.

If the error persists, call your IBM service representative.

sqlcode : -293

sqlstate : 57048

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

[Pierre Saint-Jacques]

Just to let you know for the future.
Reading a bit of the online docs allow you to lose less time waiting for an
answer !!!!!

D:\SQLLIB\BIN>db2 ? sql0293n

SQL0293N Error accessing a table space container.
Explanation:
This error may be caused by one of the following conditions:
o A container (directory, file or raw device) was not found.
o A container is not tagged as being owned by the proper table
space.

A container tag is corrupt.
This error can be returned during database startup and during
the processing of the ALTER TABLESPACE SQL statement.
User Response:
Try the following actions:
1. Check that the directory, file, or device exists and that the
file system is mounted (if it is on a separate file
system). Containers must be readable and writable by the
database instance owner.
2. If you have a recent backup, try restoring the table space or
database. If that fails because of the bad container and the
container is not a DEVICE type, try manually removing the
container first.
If the error was returned from the processing of an ALTER
TABLESPACE SQL statement with the SWITCH ONLINE option, then
re-issue the statement after correcting the problem as described
above.
If the error persists, call your IBM service representative.
sqlcode : -293
sqlstate : 57048

There's obviously a problem getting to the container.
db2 list tablespaces will show you which tablespace is not in a normal
state, it will also give you its ID as 05 for example.
db2 list tablespace containers for 05 will show you which container is
not working and then put your Windows hat on and go resolve the issue of
accessing that path.

HTH' Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Sintesi" <m.bert...@teamsintesi.com> a écrit dans le message de news:
1154557943....@p79g2000cwp.googlegroups.com...