Difference between revisions of "DB2"

From Mesopoly 3.0
Jump to navigation Jump to search
Line 7: Line 7:
 
*to catalog baze db2 catalog local node dbname
 
*to catalog baze db2 catalog local node dbname
  
==backup==
+
==Networker backup==
 +
*[https://powerlink.emc.com/nsepn/webapps/btg548664833igtcuup4826/km/appmanager/km/secureDesktop?_nfpb=true&_pageLabel=freeformlinks2&internalId=0b0140668015b0af&_irrt=true documentation]
 
*to run backup from shell  
 
*to run backup from shell  
 
  /opt/IBM/db2/V9.1/bin/db2 backup db BAZA LOAD /usr/lib/libnsrdb2.o
 
  /opt/IBM/db2/V9.1/bin/db2 backup db BAZA LOAD /usr/lib/libnsrdb2.o

Revision as of 10:07, 12 September 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

Networker backup

/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