In present, I have a DPF database (DB2/AIX64 11.1.2.2 ) defined 3 nodes and I try to extract the ddl for tablespaces but the following solutions are not "working" , let me explain :
In first time, I check if all partitions are active.
Case 1 :
I check if all partitions are up and running and all is ok
I run the commands to extract ddl for tablespaces :
db2_all "<<+0< db2look -d mydb -l -o /tmp/mydb_0_ts.sql"
db2_all "<<+1< db2look -d mydb -l -o /tmp/mydb_1_ts.sql"
db2_all "<<+2< db2look -d mydb -l -o /tmp/mydb_2_ts.sql"
I get 3 times the "same" ddl file , same contains and If I check the tablespaces , some tablespaces are missing : I have only 15 tablespaces out of 42
Case 2:
I check if all partitions are up and running and all is ok
I run the commands to extract ddl for tablespaces :
export DB2NODE=0
db2 terminate
db2look -d mydb -l -o /tmp/mydb_0_ts.sql
export DB2NODE=1
db2 terminate
db2look -d mydb -l -o /tmp/mydb_1_ts.sql
export DB2NODE=2
db2 terminate
db2look -d mydb -l -o /tmp/mydb_2_ts.sql
I get 3 times the "same" ddl file , same contains and If I check the tablespaces , some tablespaces are missing : I have only 15 tablespaces out of 42
Is there anyone who can help me?
------------------------------
Olivier Chabant
------------------------------
#AIandDSSkills#DataandAILearning