Showing posts with label DB2. Show all posts
Showing posts with label DB2. Show all posts
DB2 Utility Commands
Unknown
DB2 Utility Commands
List
the running utilities and their progress
db2
list utilities show detail
Throttle
a running utility.
First
find the Utility ID.
db2
list utilities show detail
Throttle
the utility to a value of 1 to 10. 10 being the most throttled.
db2
set UTIL_IMPACT_PRIORITY for <util_id> TO 5
8:52 AM
BASIS
,
DB2
,
MSSQL
,
SAP Beginners
DB2 Tuning Commands
Unknown
DB2 Tuning Commands
Quickly
look at some basic tuning measurements
db2
"select db_name, rows_read, rows_selected, lock_waits,
lock_wait_time, deadlocks, lock_escals, total_sorts, total_sort_time
from table (snapshot_database (' ', -1) ) as snapshot_database"
8:51 AM
BASIS
,
DB2
,
MSSQL
,
SAP Beginners
DB2 Tablespace and Bufferpool Commands
Unknown
DB2 Tablespace and Bufferpool Commands
View
the names, pagesize, and number of pages of the bufferpools in your
database
db2
"select bpname,pagesize,npages from syscat.bufferpools"
Make
a bufferpool resize automatically. You must have STMM turned on at
the database configuration level
db2
alter bufferpool bp1 size AUTOMATIC
Alter
a bufferpool size that is a fixed size
db2
ALTER BUFFERPOOL IBMDEFAULTBP SIZE 15000;
Add
space to a DMS tablespace
db2
"alter tablespace <tblspace> extend (all 8000)"
8:49 AM
ABAP
,
BASIS
,
DB2
,
MSSQL
,
SAP Beginners
DB2 Table and Index Commands
Unknown
DB2 Table and Index Commands
Look
at columns and data types of a table
db2
describe table schema.tabelename
Look
at one column's data type.
db2
"describe select <colname> from schema.tablename"
Look
at indexes on a table
db2
describe indexes for table schema.tablename
Export
data to a file in ixf format
db2
export to tablename.ixf of ixf messages tablename.txt select * from
SCHEMA.TABNAME
Import
data from an ixf file
db2
import from filename.ixf of ixf messages tablename.txt insert into
SCHEMA.TABNAME
Import
using Load which is faster (doesn't check constraints) and
NONRECOVERABLE doesn't log anything
db2
load from filename.ixf of ixf insert into SCHEMA.TABNAME
nonrecoverable;
Build
a file to set integrity on all tables that are in set integrity
pending state
db2
"select 'set integrity for '||tabschema||'.'||tabname ||'
immediate checked;' from syscat.tables where type = 'T' and status =
'C'" > file.out
8:48 AM
ABAP
,
BASIS
,
DB2
,
MSSQL
,
SAP Beginners
DB2 Security Commands
Unknown
DB2 Security Commands
Build
a script to grant user execute privilege on all packages.
db2
"select 'db2 grant execute on package
'||pkgschema||'.'||pkgname||' to user <user>;' from
syscat.packages where pkgschema = 'NULLID'" > output.file
Security
Notes
dbadm
auth must be revoked before any other database privlege
create_not_fenced_routine
must be revoked before create_external_routine
8:46 AM
BASIS
,
DB2
,
MSSQL
,
SAP Beginners
DB2 Backup and Restore Commands
Unknown
DB2 Backup and Restore Commands
Take
an OFFLINE backup
db2
connect to <dbname>
db2
quiesce database immediate force connections
db2
connect reset
db2
backup database <dbname> to <path> compress without
prompting
after
backup completes:
db2
connect to <dbname>
db2
unquiesce database
db2
connect reset
Take
an ONLINE Backup
db2
backup db <dbname> to <path> online compress
or
use a background process on a linux/unix machine
nohup
db2 backup db <dbname> to <path> online compress &
List
recent backups and where they are stored
db2
list history backup all for <dbname>
Check
the integrity of a backup image
db2ckbkp
<image name>
Restore
from Incremental Backup Automatic
db2
restore db <dbname> incremental automatic taken at <timestamp>
If
you need to restore an incremental backup manually this command will
give you the required previous backups.
db2ckrst
-d <dbname> -t <timestamp of image>
8:44 AM
BASIS
,
DB2
,
MSSQL
,
SAP Beginners
DB2 Commands Home
Unknown
Basic Commands
Size
of your database :
db2
'call get_dbsize_info(?,?,?,0)'
Version
of DB2 you are running:
db2level
Stop
the db2 instance:
db2stop
Stop
an instance that has current connections
db2
force applications all
db2
deactivate db <dbname>
db2
terminate
db2stop
force
ipclean
Start
the db2 instance:
db2start
Kill
a hung instance (last resort):
db2_kill
-all
List
the databases in an instance:
db2
list db directory
List
the cataloged nodes:
db2
list node directory
Show
the database manager configuration settings:
db2
get dbm cfg
Show
the database level configuration settings:
db2
get db cfg for <dbname>
Activate
a database:
db2
activate db <dbname>
Deactivate
a database:
db2
deactivate db <dbname>
View
the DB2 License:
db2licm
-l
To
switch between partitions:
db2
terminate; export DB2NODE=<new-node-num>
8:41 AM
BASIS
,
DB2
,
MSSQL
,
SAP Beginners
Subscribe to:
Posts
(
Atom
)
