coolcommands.com - the search engine for unix sysadmins :: unix commands and scripts
Sunday May 27, 2012


 Home
 Search
 Advanced Search
 Category Search
 Affiliates
 Acknowledgements
 Cool Links

Username

Password

Remember me
Forgot your password?
Create an account

Who's Online
We have 21 guests online

Newest Member

beyondimagem

Hit Counter
9133536 Visitors

cool Statistics
coolcommands:1330
Categories:83
Total queries:595500
Members:16437





Category Search coolcommands.com
Select Category:


coolcommand

DB2 - get IBM DB2 configuration information
Description

To get the configuration information for an IBM DB2 database:

# db2 get db cfg for dbname

Database Configuration for Database dbname

Database configuration release level = 0x0900
Database release level = 0x0900

Database territory = US
Database code page = 850
Database code set = IBM-850
Database country code = 1

Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE

Directory object name (DIR_OBJ_NAME) =
Discovery support for this database (DISCOVER_DB) = ENABLE

Default query optimization class (DFT_QUERYOPT) = 5
Degree of parallelism (DFT_DEGREE) = 1
Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO
Default refresh age (DFT_REFRESH_AGE) = 0
Number of frequent values retained (NUM_FREQVALUES) = 10
Number of quantiles retained (NUM_QUANTILES) = 20
Backup pending = NO

Database is consistent = NO
Rollforward pending = NO
Restore pending = NO

Max number of active applications (MAXAPPLS) = 100
Example

db2 get db cfg for dbname

Return to search results

Random coolcommands

coolcommand: sys-unconfig - how to clear or reset network information in Sun Solaris
Example: sys-unconfig
[show me the details]
coolcommand: chlicense - how to modify number of fixed licenses or turn floating licenses on or off in IBM AIX
Example: chlicense -u'128'
[show me the details]
coolcommand: hmcshutdown - command to shut down the Hardware Management Console
Example: hmcshutdown -t { < number-of-minutes > | now } [ -r ] [—help ]
[show me the details]
coolcommand: how to print system epoch time with nawk
Example: nawk 'BEGIN {print srand()}'
[show me the details]

coolcommands.com - the search engine for UNIX sysadmins :: unix commands and scripts



FREE
myPMS

Password
Management
System

by

LVOware.com




Top 5 Submitters

lvo1152
audet37
kah00na32
Mariom24
lebjf00014

Top 5 Searches

Category Solaris49379
Category AIX46267
Category General UNIX43933
solaris22927
aix22116

Terms of Use
Privacy
Contact


 
coolcommands.com © 2012. All Right Reserved.
Programming by PRATTICO Consulting . Hosting by Apricusum