Difference between revisions of "DB2"
Jump to navigation
Jump to search
m |
m |
||
| Line 4: | Line 4: | ||
==backup== | ==backup== | ||
| − | *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 | ||
==misc== | ==misc== | ||
| − | DB2INSTANCE=db2inst1 | + | DB2INSTANCE=db2inst1 |
| − | export DB2INSTANCE | + | export DB2INSTANCE |
Revision as of 12:08, 1 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
