Thursday, 2 June 2011

DB2 BASIC COMMANDS


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