Several DB2 common commands

xiaoxiao2021-03-06  163

Get the list of configuration parameters for the database:

DB2 GET DATABASE Configuration for Database_name

Connect to the database:

DB2 Connect to Database_name User_name Using User_password

Monitoring switch:

DB2 "Update Monitor Switch Using Lock On Sort On Bufferpool on Uow on Table on Statement On"

Workload switch:

DB2 "Get Snapshot for Database Manager"

Maximum open file:

DB2 "Get Snapshot for Database On DBNAME"

转载请注明原文地址:https://www.9cbs.com/read-128429.html

New Post(0)