db2support HTML report
_______ D B 2 S u p p o r t ______
This program generates information about a DB2 server, including
information about its configuration and system environment. The output of
this program will be stored in a file named 'db2support.zip', located
in the directory specified on the application command line. If you are
experiencing problems with DB2, it may help if this program is run
while the problem is occurring.
NOTES:
1. By default, this program will not capture any user data from tables or
logs to protect the security of your data.
2. For best results, run this program using an ID having SYSADM authority.
3. On Windows systems you should run this utility from a db2 command
session.
4. Data collected from this program will be from the machine where this
program runs. In a client-server environment, database-related
information will be from the machine where the database resides via an
instance attachment or connection to the database.
Time and date of this collection: 3/16/2010 2:29:53 PM Eastern Daylight Time
Command issued for this collection: db2support . -f -d SAMPLE -m -c -o Instance02_OUT
Table of Contents
- Machine description
- Release and configuration
- Directories
- Storage topology
- Applications
- Database specific information
- Status information
- Miscellaneous
- Workload Management Information
PMR identifier
Table of Contents
PMR number if known
A PMR number was not specified by the user.
CPU, disk, and memory info
Table of Contents
System resources (disk, CPU, memory)
Number of physical disks: 2
Physical memory: 8087 MB
Number of CPUs online and configured: 2, 0
OS level
Table of Contents
Operating system and level
Operating system is: NT 64BIT
Microsoft Windows [Version 6.1.7600]
OSS reports operating system level as: 6.1.
JDK level
Table of Contents
JDK Level
java full version "1.6.0_18-b07"
JCC version
Table of Contents
JCC Version
IBM DB2 JDBC Universal Driver Architecture 3.58.82
JCC configuration information
Table of Contents
JCC Configuration
[jcc] BEGIN TRACE_DRIVER_CONFIGURATION
[jcc] Driver: IBM DB2 JDBC Universal Driver Architecture 3.58.82
[jcc] Compatible JRE versions: { 1.4, 1.5, 1.6 }
[jcc] Target server licensing restrictions: { z/OS: disabled; SQLDS: disabled; iSeries: disabled; DB2 for Unix/Windows: enabled; Cloudscape: enabled; Informix: enabled }
[jcc] Range checking enabled: true
[jcc] Bug check level: 0xff
[jcc] Default fetch size: 64
[jcc] Default isolation: 2
[jcc] Collect performance statistics: false
[jcc] No security manager detected.
[jcc] Detected local client host: Bluesky/192.168.153.1
[jcc] Access to package sun.io is permitted by security manager.
[jcc] JDBC 1 system property jdbc.drivers = null
[jcc] Java Runtime Environment version 1.6.0_18
[jcc] Java Runtime Environment vendor = Sun Microsystems Inc.
[jcc] Java vendor URL = http://java.sun.com/
[jcc] Java installation directory = C:\Program Files (x86)\Java\jdk1.6.0_18\jre
[jcc] Java Virtual Machine specification version = 1.0
[jcc] Java Virtual Machine specification vendor = Sun Microsystems Inc.
[jcc] Java Virtual Machine specification name = Java Virtual Machine Specification
[jcc] Java Virtual Machine implementation version = 16.0-b13
[jcc] Java Virtual Machine implementation vendor = Sun Microsystems Inc.
[jcc] Java Virtual Machine implementation name = Java HotSpot(TM) Client VM
[jcc] Java Runtime Environment specification version = 1.6
[jcc] Java Runtime Environment specification vendor = Sun Microsystems Inc.
[jcc] Java Runtime Environment specification name = Java Platform API Specification
[jcc] Java class format version number = 50.0
[jcc] Java class path = C:\Program Files\IBM\SQLLIB\java\db2java.zip;C:\Program Files\IBM\SQLLIB\java\db2jcc.jar;C:\Program Files\IBM\SQLLIB\java\sqlj.zip;C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\Program Files\IBM\SQLLIB\bin;C:\Program Files\IBM\SQLLIB\java\common.jar;.;.;.;C:\Program Files (x86)\QuickTime\QTSystem\QTJava.zip
[jcc] Java native library path = C:\Program Files (x86)\Java\jdk1.6.0_18\bin;.;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files\IBM\SQLLIB\BIN;C:\Program Files\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\BIN\..\db2tss\bin;C:\Program Files (x86)\Tools;C:\Drivers\bin;C:\Program Files (x86)\Java\jdk1.6.0_18\bin;C:\Perl64\site\bin;C:\Perl64\bin;C:\oraclexe\app\oracle\product\10.2.0\server\bin;C:\Windows\system32;C:\Windows;C:\Windows\system32\wbem;C:\Windows\system32\windowspowershell\v1.0\;c:\program files (x86)\securecrt;c:\program files\ibm\gsk8\lib64;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\
[jcc] Path of extension directory or directories = C:\Program Files (x86)\Java\jdk1.6.0_18\jre\lib\ext;C:\Windows\Sun\Java\lib\ext
[jcc] Operating system name = Windows 7
[jcc] Operating system architecture = x86
[jcc] Operating system version = 6.1
[jcc] File separator ("/" on UNIX) = \
[jcc] Path separator (":" on UNIX) = ;
[jcc] User's account name = Vikram
[jcc] User's home directory = C:\Users\Vikram
[jcc] User's current working directory = C:\POT_DB2\01INSTANCE\DB2SUPPORT
[jcc] Dumping all system properties: { java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\Program Files (x86)\Java\jdk1.6.0_18\jre\bin, java.vm.version=16.0-b13, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, sun.java.launcher=SUN_STANDARD, user.country=US, sun.os.patch.level=, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\POT_DB2\01INSTANCE\DB2SUPPORT, java.runtime.version=1.6.0_18-b07, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files (x86)\Java\jdk1.6.0_18\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\Users\Vikram\AppData\Local\Temp\, line.separator=\r\n, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 7, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files (x86)\Java\jdk1.6.0_18\bin;.;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files\IBM\SQLLIB\BIN;C:\Program Files\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\BIN\..\db2tss\bin;C:\Program Files (x86)\Tools;C:\Drivers\bin;C:\Program Files (x86)\Java\jdk1.6.0_18\bin;C:\Perl64\site\bin;C:\Perl64\bin;C:\oraclexe\app\oracle\product\10.2.0\server\bin;C:\Windows\system32;C:\Windows;C:\Windows\system32\wbem;C:\Windows\system32\windowspowershell\v1.0\;c:\program files (x86)\securecrt;c:\program files\ibm\gsk8\lib64;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\, java.specification.name=Java Platform API Specification, java.class.version=50.0, sun.management.compiler=HotSpot Client Compiler, os.version=6.1, user.home=C:\Users\Vikram, user.timezone=, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.6, java.class.path=C:\Program Files\IBM\SQLLIB\java\db2java.zip;C:\Program Files\IBM\SQLLIB\java\db2jcc.jar;C:\Program Files\IBM\SQLLIB\java\sqlj.zip;C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\Program Files\IBM\SQLLIB\bin;C:\Program Files\IBM\SQLLIB\java\common.jar;.;.;.;C:\Program Files (x86)\QuickTime\QTSystem\QTJava.zip, user.name=Vikram, java.vm.specification.version=1.0, java.home=C:\Program Files (x86)\Java\jdk1.6.0_18\jre, sun.arch.data.model=32, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, sharing, java.version=1.6.0_18, java.ext.dirs=C:\Program Files (x86)\Java\jdk1.6.0_18\jre\lib\ext;C:\Windows\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files (x86)\Java\jdk1.6.0_18\jre\lib\resources.jar;C:\Program Files (x86)\Java\jdk1.6.0_18\jre\lib\rt.jar;C:\Program Files (x86)\Java\jdk1.6.0_18\jre\lib\sunrsasign.jar;C:\Program Files (x86)\Java\jdk1.6.0_18\jre\lib\jsse.jar;C:\Program Files (x86)\Java\jdk1.6.0_18\jre\lib\jce.jar;C:\Program Files (x86)\Java\jdk1.6.0_18\jre\lib\charsets.jar;C:\Program Files (x86)\Java\jdk1.6.0_18\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86 }
[jcc] Dumping all file properties: { }
[jcc] pureQuery present = false
[jcc] END TRACE_DRIVER_CONFIGURATION
DB2 release information
Table of Contents
DB2 Release Info
Server is running MPP/EEE (single node).
DB21085I Instance "DB2" uses "64" bits and DB2 code release "SQL09072" with
level identifier "08030107".
Informational tokens are "DB2 v9.7.200.266", "s100211", "IP23058", and Fix Pack
"2".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB" with DB2 Copy Name "DB297".
DB2 install path
Table of Contents
Shared install & library info
Instance name is: DB2
Install path for the default instance is: C:\PROGRA~1\IBM\SQLLIB
Environment registry
Table of Contents
Registry variables
DBI1314I Listing all supported registry variables...
DBI1314I Listing all supported registry variables...
[e] DB2PATH=C:\Program Files\IBM\SQLLIB
[i] DB2_COMPATIBILITY_VECTOR=ORA
[i] DB2INSTOWNER=BLUESKY
[i] DB2PORTRANGE=60000:60003
[i] DB2INSTPROF=C:\PROGRAMDATA\IBM\DB2\DB297
[i] DB2COMM=TCPIP
[g] DB2_EXTSECURITY=NO
[g] DB2SYSTEM=BLUESKY
[g] DB2PATH=C:\Program Files\IBM\SQLLIB
[g] DB2INSTDEF=DB2
[g] DB2ADMINSERVER=DB2DAS00
All instance profiles
DBI1311I Listing registry instance profiles...
DB2JNK
DB2BKP
DB2
DB2 EEE nodes information
Table of Contents
EEE node configuration
Number of nodes in db2nodes.cfg is: 1
Current node number is: 0
Node information from the db2nodes.cfg file:
0 Bluesky BLUESKY 0
Database manager configuration
Table of Contents
Get dbm cfg
GET DBM CFG
Database Manager Configuration
Node type = Enterprise Server Edition with local and remote clients
Database manager configuration release level = 0x0d00
Maximum total of files open (MAXTOTFILOP) = 16000
CPU speed (millisec/instruction) (CPUSPEED) = 2.125549e-007
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+002
Max number of concurrently active databases (NUMDB) = 8
Federated Database System Support (FEDERATED) = NO
Transaction processor monitor name (TP_MON_NAME) =
Default charge-back account (DFT_ACCOUNT_STR) =
Java Development Kit installation path (JDK_PATH) = C:\PROGRA~1\IBM\SQLLIB\java\jdk
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) =
Size of rotating db2diag & notify logs (MB) (DIAGSIZE) = 0
Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = OFF
Lock (DFT_MON_LOCK) = OFF
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = OFF
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = OFF
Monitor health of instance and databases (HEALTH_MON) = ON
SYSADM group name (SYSADM_GROUP) =
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
SYSMON group name (SYSMON_GROUP) =
Client Userid-Password Plugin (CLNT_PW_PLUGIN) =
Client Kerberos Plugin (CLNT_KRB_PLUGIN) = IBMkrb5
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
Cluster manager (CLUSTER_MGR) =
Database manager authentication (AUTHENTICATION) = SERVER
Alternate authentication (ALTERNATE_AUTH_ENC) = NOT_SPECIFIED
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO
Default database path (DFTDBPATH) = C:
Database monitor heap size (4KB) (MON_HEAP_SZ) = AUTOMATIC(66)
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC(1720971)
Backup buffer default size (4KB) (BACKBUFSZ) = 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024
Agent stack size (AGENT_STACK_SZ) = 16
Minimum committed private memory (4KB) (MIN_PRIV_MEM) = 32
Private memory threshold (4KB) (PRIV_MEM_THRESH) = 20000
Sort heap threshold (4KB) (SHEAPTHRES) = 0
Directory cache support (DIR_CACHE) = YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Max requester I/O block size (bytes) (RQRIOBLK) = 32767
Query heap size (4KB) (QUERY_HEAP_SZ) = 1000
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
Priority of agents (AGENTPRI) = SYSTEM
Agent pool size (NUM_POOLAGENTS) = AUTOMATIC(100)
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC(200)
Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS)
Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) = AUTOMATIC(MAX_COORDAGENTS)
Initial number of fenced processes (NUM_INITFENCED) = 0
Index re-creation time and redo index build (INDEXREC) = RESTART
Transaction manager database name (TM_DATABASE) = 1ST_CONN
Transaction resync interval (sec) (RESYNC_INTERVAL) = 180
SPM name (SPM_NAME) = BLUESKY
SPM log size (SPM_LOG_FILE_SZ) = 256
SPM resync agent limit (SPM_MAX_RESYNC) = 20
SPM log path (SPM_LOG_PATH) =
NetBIOS Workstation name (NNAME) =
TCP/IP Service name (SVCENAME) = db2c_DB2
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE
SSL server keydb file (SSL_SVR_KEYDB) =
SSL server stash file (SSL_SVR_STASH) =
SSL server certificate label (SSL_SVR_LABEL) =
SSL service name (SSL_SVCENAME) =
SSL cipher specs (SSL_CIPHERSPECS) =
SSL versions (SSL_VERSIONS) =
SSL client keydb file (SSL_CLNT_KEYDB) =
SSL client stash file (SSL_CLNT_STASH) =
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO
Maximum Asynchronous TQs per query (FEDERATED_ASYNC) = 0
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC(4096)
No. of int. communication channels (FCM_NUM_CHANNELS) = AUTOMATIC(2048)
Node connection elapse time (sec) (CONN_ELAPSE) = 10
Max number of node connection retries (MAX_CONNRETRIES) = 5
Max time difference between nodes (min) (MAX_TIME_DIFF) = 60
db2start/db2stop timeout (min) (START_STOP_TIME) = 10
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL09072
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 00000
Audit configuration
Table of Contents
db2audit describe
DB2 AUDIT SETTINGS:
Audit active: "FALSE "
Log audit events: "FAILURE"
Log checking events: "FAILURE"
Log object maintenance events: "FAILURE"
Log security maintenance events: "FAILURE"
Log system administrator events: "FAILURE"
Log validate events: "FAILURE"
Log context events: "NONE"
Return SQLCA on audit error: "FALSE "
Audit Data Path: ""
Audit Archive Path: ""
AUD0000I Operation succeeded.
ATTACH TO DB2
Instance Attachment Information
Instance server = DB2/NT64 9.7.2
Authorization ID = VIKRAM
Local instance alias = DB2
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 40
sqlerrmc: 1˙1252˙VIKRAM ˙DB2˙QDB2/NT64˙63˙63˙0˙1˙
sqlerrp : SQL09072
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 1 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 00000
Admin Server Configuration
Table of Contents
Get admin cfg
GET ADMIN CFG
Admin Server Configuration
Authentication Type DAS (AUTHENTICATION) = SERVER_ENCRYPT
DAS Administration Authority Group Name (DASADM_GROUP) =
DAS Discovery Mode (DISCOVER) = SEARCH
Name of the DB2 Server System (DB2SYSTEM) = BLUESKY
Java Development Kit Installation Path DAS (JDK_PATH) = AUTOMATIC (C:\Program Files\IBM\SQLLIB\java\jdk)
Java Development Kit Installation Path DAS (JDK_64_PATH) = AUTOMATIC (C:\Program Files\IBM\SQLLIB\java\jdk)
DAS Code Page (DAS_CODEPAGE) = 0
DAS Territory (DAS_TERRITORY) = 0
Location of Contact List (CONTACT_HOST) =
Execute Expired Tasks (EXEC_EXP_TASK) = NO
Scheduler Mode (SCHED_ENABLE) = ON
SMTP Server (SMTP_SERVER) =
Tools Catalog Database (TOOLSCAT_DB) = TOOLSDB
Tools Catalog Database Instance (TOOLSCAT_INST) = DB2
Tools Catalog Database Schema (TOOLSCAT_SCHEMA) = SYSTOOLS
Scheduler User ID =
Diagnostic error capture level (DIAGLEVEL) = 3
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL09072
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
List of databases
Table of Contents
List database directory
LIST DB DIRECTORY
System Database Directory
Number of entries in the directory = 3
Database 1 entry:
Database alias = DW
Database name = DW
Local database directory = C:
Database release level = d.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database 2 entry:
Database alias = TOOLSDB
Database name = TOOLSDB
Local database directory = C:
Database release level = d.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database 3 entry:
Database alias = SAMPLE
Database name = SAMPLE
Local database directory = C:
Database release level = d.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL09072
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 00000
Node directory information
Table of Contents
List node directory show detail
LIST NODE DIRECTORY SHOW DETAIL
Node Directory
Number of entries in the directory = 2
Node 1 entry:
Node name = DB2BKP
Comment =
Directory entry type = LOCAL
Protocol = LOCAL
Instance name = DB2BKP
Remote instance name =
System = BLUESKY
Operating system type = WIN
Node 2 entry:
Node name = DB2JNK
Comment =
Directory entry type = LOCAL
Protocol = LOCAL
Instance name = DB2JNK
Remote instance name = DB2JNK
System = BLUESKY
Operating system type = NT64
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL09072
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 00000
Admin node directory
Table of Contents
List admin node directory show detail
LIST ADMIN NODE DIRECTORY SHOW DETAIL
Node Directory
Number of entries in the directory = 1
Node 1 entry:
Node name = BLUESKY
Comment = Local workstation
Directory entry type = LOCAL
Protocol = LOCAL
Instance name = DB2DAS00
Remote instance name =
System = BLUESKY
Operating system type = NT64
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL09072
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 00000
DCS directory
Table of Contents
List DCS directory
LIST DCS DIRECTORY
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1311 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL09072
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Problem Determination Settings
Table of Contents
Problem determination settings
Current PD Control Block Settings:
All error catch flag settings cleared.
db2cos is enabled for engine traps.
PD Bitmap: 0x1000
Sleep Time: 3
Timeout: 300
Current Count: 0
Max Count: 255
Current bitmap value: 0x0
fopen failed with errno 5.
Status of db2trc
Table of Contents
Status of db2trc
CLI configuration
Table of Contents
Get cli cfg
get CLI cfg
Section: tstcli1x
-------------------------------------------------
uid=userid
pwd=*****
autocommit=0
TableType='TABLE','VIEW','SYSTEM TABLE'
Section: tstcli2x
-------------------------------------------------
SchemaList='OWNER1','OWNER2',CURRENT SQLID
Section: MyVeryLongDBALIASName
-------------------------------------------------
dbalias=dbalias3
SysSchema=MYSCHEMA
DCS applications
Table of Contents
List DCS applications extended
LIST DCS APPLICATIONS EXTENDED
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1032 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLJCMN
sqlerrd : (1) -2127167470 (2) 18 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 57019
Client connection state
Table of Contents
Query client
QUERY CLIENT
The current connection settings of the application process are:
CONNECT = 1
DISCONNECT = EXPLICIT
MAX_NETBIOS_CONNECTIONS = 0
SQLRULES = DB2
SYNCPOINT = ONEPHASE
CONNECT_DBPARTITIONNUM = -1
ATTACH_DBPARTITIONNUM = -1
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL09072
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 00000
Active databases
Table of Contents
List active databases
LIST ACTIVE DATABASES
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1032 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLJCMN
sqlerrd : (1) -2127167470 (2) 18 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 57019
terminate
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL09072
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Database configuration
Table of Contents
DB CFG for node 0
Get db cfg for SAMPLE
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1032 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLJCMN
sqlerrd : (1) -2127167470 (2) 18 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 57019
Optimizer database configuration
Table of Contents
Optimizer database configuration
Node 0:
call to get API (sqlfxdb) failed
sqlcode = -1032.
sqlstate = "57019".
Recovery history file
Table of Contents
List history since 20100216 for db SAMPLE
List history since 20100216 for db SAMPLE
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1032 sqlerrml: 0
sqlerrmc:
sqlerrp : db2Histo
sqlerrd : (1) -2127167470 (2) 18 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 57019
Buffer pool information
Table of Contents
List applications for database SAMPLE global show detail
List applications for database SAMPLE global show detail
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1032 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLJCMN
sqlerrd : (1) -2127167470 (2) 18 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 57019
terminate
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL09072
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
terminate
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL09072
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
terminate
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL09072
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: