Results 1 to 7 of 7

Thread: the catalog DB2

  1. #1
    Join Date
    Sep 2006
    Posts
    3

    Unanswered: the catalog DB2

    Personal I am new with DB2 and I need a help.

    I need to recreate the catalog of DB2 (V. 7.2), how do I make that..?

    Thank you

    Mendez

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    catalog

    if you mean something like catalog.sql of ora : this is not possible
    db2 created the catalog itself - no user action involved - as simple as create database command
    why would you re-create the catalog
    drop-create db : and save data before if any
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Sep 2006
    Posts
    3
    Hi,

    we have ourselves SAP, with DB2 and the support I sent a note so that
    the catlog was used the commands..

    db2 UNCATALOG DB <sid>

    db2 CATALOG DB <sid> THE <newname>

    db2 CATALOG TCPIP NODE <node> REMOTE 127.0.0.1 SERVER <service>

    db2 CATALOG DB <newname> THE <sid> ATTN NODE <node>

    this would be the solution

    I have mine doubt

  4. #4
    Join Date
    Jun 2006
    Posts
    471

    catalo

    db2 UNCATALOG DB <dbname> <<- to uncatalog the database name : local or remote
    db2 CATALOG DB <dbname> THE <newname> <-- should be
    db2 catalog db xx as yy only if xx has already been cataloged
    db2 CATALOG TCPIP NODE <node> REMOTE 127.0.0.1 SERVER <service>
    to catalog the machine/port where instance is running
    db2 CATALOG DB <dbname> THE <sid> ATTN NODE <node>
    what is THE and TN
    db2 catalog db (as newname) at node xxxx
    this should work..
    db2 catalog db xx on /xx/xx if local
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  5. #5
    Join Date
    Sep 2006
    Posts
    3
    only a question.... I am new with the db2.

    as I find the name of Node and I number ... the port

    San

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    catalog

    db2 CATALOG TCPIP NODE <node> REMOTE 127.0.0.1 SERVER <service>
    node can be any name of your choice as long as you use the same name with catalog db at node xx
    127.0.0.1 should be the ipaddress or hostname of the server where the db2instance is running. only in case of remote. local databases do not need tcpip access but use interprocess communication
    service=port nbr
    from existing instance :
    db2 get dbm cfg |grep SVCENAME
    if this is a symbolic name then
    look in /etc/services and find this name, that will be mapped to a port in /etc/services or on windows c:\windows\system32\drivers\etc\services
    otherwise this is a port nbr.
    if local db from user other then instance owner (where db is already created and automatically cataloged)
    db2 catalog local node xxx instance instancename
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  7. #7
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    catalog

    or read the tutorial to exam 730 that will explain all this basic stuff
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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