LIST DB2 INSTANCE
=================
db2ilist
CREATE DB2 INSTANCE
===================
db2icrt datta
DROP INSTANCE
==============
db2idrop datta
CHECK CURRENT INSTANCE
======================
db2 get instance
CHANGE INSTANCE
================
set db2instance=dmc
START INSTANCE
===============
db2start
STOP INSTANCE
=============
db2stop
DISPLAY ALL PARAMETERS FOR CURRENT INSTANCE
======================
db2 get dbm cfg
CHANGE PARAMETER
===================
db2 update dbm cfg using PARAMETER VALUE
CONNECT TO DATABASE
====================
db2 connect to sample
DB PARAMETERS
==============
db2 get db cfg for sample
CREATE DATABASE
===============
db2 create db testdb
DROP DATABASE
==============
db2 drop db testdb
LIST DIRECTORIES
==================
db2 list db directory
No comments:
Post a Comment