Difference between revisions of "DB2"

From Mesopoly 3.0
Jump to navigation Jump to search
m
m
Line 1: Line 1:
 
==baza==
 
==baza==
 
*to create baze with CODEPAGE defined - DB2 CREATE DATABASE dbname USING CODESET UTF-8 TERRITORY US
 
*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==
 
==backup==
 
*to run backup from shell / /opt/IBM/db2/V9.1/bin/db2 backup db BAZA LOAD /usr/lib/libnsrdb2.o
 
*to run backup from shell / /opt/IBM/db2/V9.1/bin/db2 backup db BAZA LOAD /usr/lib/libnsrdb2.o

Revision as of 12:10, 28 March 2008

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