Hi,

I have the same problem as sosdb:
http://www.dbforums.com/archive/inde...t-1218647.html

AIX 5.3, DB2 UDB 8.2 Fixpak 11
I want to change tablespace containers from files to RAW devices via a redirect restore.

db2 restore db AAA from /backup/20070429AAA/ replace existing redirect without rolling forward;
db2 "set tablespace container for 1 using (device '/dev/rATEMP1' 512M, device '/dev/rATEMP2' 512M)";
db2 restore db AAA continue;

The RAW devices /dev/rATEMP1 and /dev/rATEMP2 are defined and chown.

I got "done successfully" reply with command 1 and 2, but got an error when continue with restore.

SQL1651N The request cannot be executed because the DB2 server version does not support this functionality.

And I found when containers been set to RAW devices, all DB2 command will got a SQL1651N error, for example, db2 list tablespaces.

I have check db2diag.log,

2007-04-29-22.23.16.734174+480 E3764A360 LEVEL: Error (OS)
PID : 630842 TID : 1 PROC : db2bp
INSTANCE: db2cml NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloxltc_app, probe:15
CALLED : OS, -, unspecified_system_function
OSERR : EINVAL (22) "A system call received a parameter that is not valid."

And found probe 15 in error.h is

#define ENOTBLK 15 /* Block device required */

Does redirect restore from files to RAW devices is supported by DB2 8.2?

Please help, thanks!

You can not redirect restore from SMS to DMS tablespaces. The tablespace type should be the same. Only the containers can be changerd.

Hi Nagasurir,

Thanks for your reply, but I am redirect restore from DMS to DMS tablespaces.
Would you please give me some further advices?
Thanks in advance.

Regards,

Harward Gao

Hi Nagasurir,

In additional, after I defined containers for any one DMS or SMS when I redirect restore any database, DB2 commands can not be excuted.
For example, I can list tablespaces when a redirect restore started, but I cannnot after a container definition.
I really got bother about this for some days, any advice is greatly appreciated.

Regards,

Harward Gao

Hello,

I am having the same error message during Redirect restore. How did you resolve your issue?

Thank you

should not your set containers for all tablespaces (not just one)?

manual says you need to 'list tablespaces show detail' after your restore command and than set all tablespace containers one by one...