AI and DS Skills

 View Only

DB2 - db2look with partitioned database

  • 1.  DB2 - db2look with partitioned database

    Posted Fri October 07, 2022 08:51 AM

    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