Difference between revisions of "DB2"

From Mesopoly 3.0
Jump to navigation Jump to search
Line 1: Line 1:
 
==installation==
 
==installation==
*[http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.uprun.doc/doc/r0008857.htm installation requirements] for [[AIX]] environment
+
*[http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.uprun.doc/doc/r0008857.htm installation requirements] for [[AIX]] environment
 +
*[http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.uprun.doc/doc/t0008875.htm installation steps] (AIX)
  
 
==baza==
 
==baza==

Revision as of 11:04, 28 August 2008

installation

baza

  • to create baze with CODEPAGE defined - DB2 CREATE DATABASE dbname USING CODESET UTF-8 TERRITORY US
  • to catalog baze db2 catalog local node dbname

backup

  • to run backup from shell
/opt/IBM/db2/V9.1/bin/db2 backup db BAZA LOAD /usr/lib/libnsrdb2.o

problem with backup

DB2INSTANCE=db2inst1
export DB2INSTANCE
  • list of DB2 sqlcode errors

misc