Difference between revisions of "DB2"

From Mesopoly 3.0
Jump to navigation Jump to search
Line 15: Line 15:
  
 
*[https://forums.emc.com/nsepn/webapps/xpsgggfs31465mnldcpq14543562/forums/thread.jspa?tstart=0&threadID=51418 Thread: Scheduled backups fail on DB2 Version 9.1 on AIX 5.3]
 
*[https://forums.emc.com/nsepn/webapps/xpsgggfs31465mnldcpq14543562/forums/thread.jspa?tstart=0&threadID=51418 Thread: Scheduled backups fail on DB2 Version 9.1 on AIX 5.3]
−
*https://powerlink.emc.com/nsepn/webapps/btg548664833igtcuup4826/km/live1/en_US/Offering_Technical/Technical_Documentation/300-004-742_a07_elccnt_0.pdf?mtcs=ZXZlbnRUeXBlPUttQ2xpY2tTZWFyY2hSZXN1bHRzRXZlbnQsZG9jdW1lbnRJZD0wOTAxNDA2NjgwMzEwNjM0LGRhdGFTb3VyY2U9RENUTV9lbl9VU18w LGTsc00810 & LGTpa91317] Release Notes for 2.1
+
*[https://powerlink.emc.com/nsepn/webapps/btg548664833igtcuup4826/km/live1/en_US/Offering_Technical/Technical_Documentation/300-004-742_a07_elccnt_0.pdf?mtcs=ZXZlbnRUeXBlPUttQ2xpY2tTZWFyY2hSZXN1bHRzRXZlbnQsZG9jdW1lbnRJZD0wOTAxNDA2NjgwMzEwNjM0LGRhdGFTb3VyY2U9RENUTV9lbl9VU18w LGTsc00810 & LGTpa91317] Release Notes for 2.1
  
 
*[http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/rsql1000.htm list] of DB2 sqlcode errors
 
*[http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/rsql1000.htm list] of DB2 sqlcode errors

Revision as of 12:04, 8 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

misc

DB2INSTANCE=db2inst1
export DB2INSTANCE
  • list of DB2 sqlcode errors
Retrieved from "https://vinodol.com/moki/index.php?title=DB2&oldid=3302"