|
|
abukta
super admin
profile |
|
Join Date: 29 Mar 2005 21:03
Posts: |
|
|
db2 list database directory : to see all the database directory entries (i.e., aliases).
db2 list node directory : to see all the database nodes (i.e., related database directory node info to this info).
db2 catalog admin tcpip node remote : create an alias that can be used to remotely administer db2.
db2 connect to
db2 reorgchk update statistics on table all: to update statistics on all tables.
db2 reorg table swbapps. : to update statistics on one table.
db2rbind /l : done outside db2cmd after a db2 reorg to rebind packages to tables.
update database manager configuration using JDK11_PATH /usr/java1.1.8
: IBM has certified DB2 against JDK 1.1. this command updates the DB2 manager to Reference the locally installed JDK 1.1.8
db2level : display version information (works on all platforms)
db2ilist : list all instance names on the local machine (see the bin directory or commands reference for all db2i commands)
dasilist : list all administration server names on the local machine.
|
Home 
Forum
DB2 UDB Commands
