Difference between revisions of "DB2"
Jump to navigation
Jump to search
m |
|||
| (16 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== |
| − | *to run backup from shell | + | *[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 | ||
| + | /opt/IBM/db2/V9.1/bin/db2 backup db BAZA LOAD /usr/lib/libnsrdb2.o | ||
| + | *[https://forums.emc.com/nsepn/webapps/xpsgggfs31465mnldcpq14543562/forums/forum.jspa?forumID=68 EMC netwoker forum] | ||
| + | *Legato (EMC) Networker product updates [ftp://ftp.legato.com/pub/NetWorker/Updates download] by ftp | ||
| + | |||
| + | ==problem with backup== | ||
| + | |||
| + | DB2INSTANCE=db2inst1 | ||
| + | export DB2INSTANCE | ||
| + | |||
| + | *[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 | ||
| + | |||
| + | *[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) | ||
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)
