Difference between revisions of "DB2"
Jump to navigation
Jump to search
m |
|||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | ==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/t0008875.htm installation steps] (AIX) | ||
| + | |||
==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 | *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] (use left menu for version) | ||
*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 | ||
| Line 9: | Line 14: | ||
*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 | ||
| − | == | + | ==problem with backup== |
DB2INSTANCE=db2inst1 | DB2INSTANCE=db2inst1 | ||
| Line 18: | Line 23: | ||
*[http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/rsql1200.htm list] of DB2 sqlcode errors | *[http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/rsql1200.htm list] of DB2 sqlcode errors | ||
| + | |||
| + | *[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) | ||
Latest revision as of 10:10, 12 September 2008
installation
- installation requirements for AIX environment
- installation steps (AIX)
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
- documentation (use left menu for version)
- to run backup from shell
/opt/IBM/db2/V9.1/bin/db2 backup db BAZA LOAD /usr/lib/libnsrdb2.o
- EMC netwoker forum
- Legato (EMC) Networker product updates download by ftp
problem with backup
DB2INSTANCE=db2inst1 export DB2INSTANCE
- Thread: Scheduled backups fail on DB2 Version 9.1 on AIX 5.3
- LGTsc00810 & LGTpa91317 Release Notes for 2.1
- list of DB2 sqlcode errors
misc
- http://www.hpss-collaboration.org/hpss/index.jsp (high performance storage system)
