Difference between revisions of "DB2"

From Mesopoly 3.0
Jump to navigation Jump to search
Line 9: Line 9:
 
*Legato (EMC) Networker product updates [ftp://ftp.legato.com/pub/NetWorker/Updates download] by ftp
 
*Legato (EMC) Networker product updates [ftp://ftp.legato.com/pub/NetWorker/Updates download] by ftp
  
==misc==
+
==problem with backup==
  
 
  DB2INSTANCE=db2inst1
 
  DB2INSTANCE=db2inst1
Line 20: Line 20:
  
 
*[http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0001917.htm Threaded Applications with Concurrent Access]  
 
*[http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0001917.htm Threaded Applications with Concurrent Access]  
 +
 +
==misc==
 +
 +
 
*http://www.hpss-collaboration.org/hpss/index.jsp (high performance storage system)
 
*http://www.hpss-collaboration.org/hpss/index.jsp (high performance storage system)

Revision as of 08:55, 11 April 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

problem with backup

DB2INSTANCE=db2inst1
export DB2INSTANCE
  • list of DB2 sqlcode errors

misc