Results 1 to 4 of 4

Thread: Catalog issue

  1. #1
    Join Date
    May 2013
    Posts
    3

    Unanswered: Catalog issue

    Hi Friends,

    Anybody can you please look into this.

    I need to catalog the two databases in diffrent servers for log utilization.

    For example log utilization scripts are available in SERVER1 and database name is DB1.

    2nd server is SERVER2 and database name is DB2. Here i want to catalog the DB2 database with DB1 database. DB1 database generates the log utilization report dor DB2 database.

    Here i prepared the below script for catalog, can any body please check if it is correct or wrong and how to find the node name of the DB2 database ?

    I ran the "db2 list node directory " command but nothing is there.


    Iam planning to run the below script in SERVER1.
    ================================================== =======
    connect to DB1;

    catalog tcpip node < > remote SERVER2 server 30203;

    terminate;

    catalog db DB2 as DB2 at node < > authentication server;

    terminate;

    ================================================== ========
    Last edited by swathi1234; 05-10-13 at 02:42.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You make up the node name yourself. Then use the node name when cataloging the database using a particular node.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    May 2013
    Posts
    3
    Thanks for reply.

    So the below script is good to run on the SERVER1, can you please check and suggest me.

    ================================================== =======
    connect to DB1;

    catalog tcpip node SER2_2 remote SERVER2 server 30203;

    terminate;

    catalog db DB2 as DB2 at node SER_2 authentication server;

    terminate;

    ================================================== ========

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you can successfully ping SERVER2 then it looks OK. But I like to include the full domain name (SERVER2.xxxxx.com or whatever).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •