ADMIN_MOVE_TABLE Procedure ?

[Fin]

I am looking to reconfigure my bufferpools in an very memory limited
environment. To that end I have numerous tables that I need to move to
different tablespaces. Same schema//table_name, just a different
location for the table and indexes, ideally a seperate tablespace
location for the indexes. At the time of performing such, there would
be no users connected to the db. DB2 Express-C 9.7.4

I have looked at all the online documentation which I find very
confusing as if doesn't explain each of the parameters other than the
existing schema, table_name. Online documentation gives the following
example. I have added the coments

CALL SYSPROC.ADMIN_MOVE_TABLE(
'SVALENTI', --schema
'T1', --table_name
'ACCOUNTING',--new data tablespace ????
'ACCOUNTING',--new index tablespace ????
'ACCOUNTING',--new long tablespace ????
'', --???
'', --???
'', --???
'', --???
'', --???
'MOVE') --action

My other major concern other than the actual moving, is what about the
existing relationships to views, functions, proceduresm foreign keys
etc, Are all these unaffected, redirected, rebound I mean some of the
tables I want to move have many MANY related objects. The
documentation is very poor in mentioning the effect using this
procedure may have on such.

Can some kind soul please explain and point me to some working
examples with comments and confirm re:related objects ?

Many thanks.

[Serge Rielau]

I this the entry you looked at?
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.rtn.doc/doc/r0055069.html

Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW, IBM Toronto Lab
Blog: tinyurl.com/SQLTips4DB2
Wiki: tinyurl.com/Oracle2DB2Wiki
Twitter: srielau

[Fin]

LOL .. Nope, that was definately NOT the page I found when searching
for details. That is exactly what I needed.

No mention of referenced UDF's or Procedures however. I know when I go
to drop a table for example that has UDFs referenced to it, it will
NOT allow me to drop and gives the SPECIFICNAME as reference. The
article does mention views and Foreign Keys (Not supported) but no
mention of UDFs or procedures.

When searching for admin_move_table I ended up with these 2 at the top
among others :

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.sql.rtn.doc/doc/r0055069.html
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.sql.rtn.doc/doc/r0055069.html

Upon looking further, that page you referenced appears about 10th in
the list.

Thanks Serge

[Fin]

I figured my own way out of this one, by using the new AUTO_REVAL
registry param it appears that it will solve the dilemma.

Just so anyone who has the same issue knows.