DB2 Help

DB2 Commands

Connect:
db2 connect to [some_database] user [user_id] using [user_password]

Querry:
db2 select * from [database].[table]
db2 select [column_name1],[column_name2] from [database].[table] where [column_name]=[column_value]
db2 select * from siebel.s_lst_of_val_if where row_id='1+1Y+1'

Count:
db2 select count([colum_name]) from [table_name]
db2 select count(*) from [table_name]

Update:
db2 update [table_name] set [column_name]=[new_value] where [column_name]=[some_value]
db2 update s_asgn_grp set asgn_type_cd = 'One, Best Fit' where row_id='1+1Y+1'

Delete:
db2 delete from [database_name].[table_name] where [column_name]=[column_value]
db2 delete from siebel.s_lst_of_val_if where row_id='1+1Y+1'

List Information:
db2 list tables
db2 list tables for schema [user_name or schema_name]
db2 list database directory

Catalog:
db2 catalog tcpip node [server_name] remote [server_name] server [port_number]
db2 catalog database [database_name] at node [server_name]

Uncatalog:
db2 uncatalog database [database_name]

Create:
db2 create database [database_name] on [drive_letter]
db2 create database TEST on d

Execute SQL from text files:
db2 -tf [text_file_with_sql]
db2 -tf text.sql

Catalog Databases:
db2 catalog tcpip node X2I2D500 remote X2DBD500 server 50002 remote_instance db2inst2 ostype MVS
db2 catalog database at node X2I2D500 authentication dcs
db2 catalog dcs database as parms ',,INTERRUPT_ENABLED,,,,,'
db2 catalog system odbc data source