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

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

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

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

only a question.... I am new with the db2.

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

San

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

or read the tutorial to exam 730 that will explain all this basic stuff