DB2 Database migration from Linux to Windows Steps

By -
1. Get the ddl from linux system by using the following command.
        This ddl contains the table structures and associated indexes and sequesenses for a perticular  
         Schema.
     db2look -d <db_name> -z <schema_name> -e |tee <Filename>.ddl

2. Export the data from the Database for a perticular schema using the following command.
           db2move <DB_NAME> export -sn <schema_Name>
            -- This will generate one .lst file and multiple .ixf,.msg files

3. Transfer the files generated in the above step to the windows system.

4. create the Database,bufferpool,tablespaces and schema manually in the windows machine using the following commands.
       1. create db <DB_NAME>;

       2. CREATE BUFFERPOOL <BUFFER_POOL_NAME> IMMEDIATE
            ALL DBPARTITIONNUMS  SIZE AUTOMATIC
            NUMBLOCKPAGES 0
            PAGESIZE 8 K;
       3. CREATE REGULAR TABLESPACE <TABLESPACE_NAME>
           PAGESIZE 8 K
           MANAGED BY AUTOMATIC STORAGE
           AUTORESIZE YES
           BUFFERPOOL <BUFFER_POOL_NAME>
           OVERHEAD 7.5
            TRANSFERRATE 0.06;
       4. CREATE SCHEMA <SCHEMA_NAME> AUTHORIZATION "DB2INST2";
               Make Sure the PAGESIZE of tablespace as same as associated bufferpool size.
5. Run the ddl to create the tables and associated sequences and indexes using the below command.
     db2 -tsvf <file_name>.ddl( which is generated in 1st step)

6. import the data to the database using the below command.
     db2move <DB_NAME> load
         -- which looks the .lst file generated 2nd step and uses ixf files to load the data with out   
             checking any contraints.

7. Run the below command to set the integrity for all tables.
    1. Generate the script to set the integrity for all tables in a schema
             db2 -x "select 'set integrity for ' || rtrim(tabschema) || '.' || rtrim(tabname) || ' immediate  
             checked;' from syscat.tables where tabschema='<schema_name>'"|tee set_integrity.sql
    2. Run the script generated
              db2 -tvf set_integrity.sql

8. Run the below command to reorg all tables.
    1. Generate the script to set the integrity for all tables in a schema
             db2 -x "select 'reorg table ' || rtrim(tabschema) || '.' || rtrim(tabname) || ';' from syscat.tables
             where tabschema='<schema_name>'"|tee reorg.sql
    2. Run the script generated
              db2 -tvf reorg.sql

9. Give the grants to the tables and sequences as per your requirements.

Comments

Post a Comment

Popular posts from this blog

Jenkins Dynmaic Parameter - List All Branches in a Git Repository

By -
The below code lists all the branches from a Git Repo as a drop down in jenkins. proc1 = ['/bin/bash', '-c', "git ls-remote -h ssh://ssh@<GitURL>/<projectkey>/<RepoName>.git"].execute() proc2 = ['/bin/bash', '-c', "awk '{print \$2}'"].execute() proc3 = ['/bin/bash', '-c', "sed s%^refs/heads%origin%"].execute() all = proc1 | proc2 | proc3 String result = all.text def values = result.tokenize() return values Steps to Add this code. 1. Login to Jenkins 2. Go to your Job Configuration 3. Select this Project is Parameterized 4. Select Active Choices Reactive Parameter 5. Click on Radio Button Groovy Script 6. Add the above code. 7.Save the Job. Examples: <GitURL> :  ssh://ssh@ bitbucket.com:7999 <projectkey>:  sm <RepoName>: MyTestRepo
Read more

JMSWMQ2013: The security authentication was not valid that was supplied for QueueManager 'XYZ' with connection mode 'Client' and host name 'x.x.x.x(1415)'. Please check if the supplied username and password are correct on the QueueManager to which you are connecting.

By -
Check the corresponding user has following permissions dspmq -t qmgr -m <QMGR_NAME> -p <USER> connect inq set altusr crt dlt chg dsp setid setall ctrl system If not set the authentication permissions by running the below command setmqaut -t qmgr -m <QMGR_NAME> -p <USER>  +connect +inq +set +altusr +crt +dlt +chg +dsp +setid +setall +ctrl +system
Read more