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


  1. Machine description

  2. Release and configuration

  3. Directories

  4. Storage topology

  5. Applications

  6. Database specific information

  7. Status information

  8. Miscellaneous

  9. 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: