DB2 (LDAP)  - Created Monday 20 October 2014

 

INFO

syscheck called by root

LDAP DB2 user account: Home

Sequence: 520  - Command: lsuser -f -a pgrp groups home shell login rlogin registry SYSTEM account_locked ldapdb2

ldapdb2:  
pgrp dbsysadm 
groups dbsysadm,staff,idsldap,dasadm1 
home /home/ldapdb2 
shell /usr/bin/ksh 
login true 
rlogin true 
registry files 
SYSTEM compat 
account_locked false 
  
LDAP DB2 user processes: Home

Sequence: 521  - Command: ps -fu ldapdb2

UID  PID  PPID  STIME  TTY  TIME  CMD  
ldapdb2  5046432  Oct  15  0:09 /opt/IBM/ldap/V6.1/sbin/64/ibmslapd -I ldapdb2 -f/home/ldapdb2/idssla 
ldapdb2  5242892  7733256  Oct  15  0:00 db2srvlst 0  
ldapdb2  6029420  7667958  Oct  15  0:02 db2sysc 0  
ldapdb2  6225970  6029420  Oct  15  0:00 db2resync 0  
ldapdb2  6750438  6029420  Oct  15  0:00 db2tcpcm 0  
ldapdb2  7340042  6029420  Oct  15  0:00 db2ipccm 0  
ldapdb2  7733256  6029420  Oct  15  0:00 db2gds 0  
ldapdb2  7798838  6029420  Oct  15  0:00 db2spmrsy 0  
ldapdb2  7929856  6029420  Oct  15  0:00 db2tcpcm 0  
ldapdb2  7995636  7733256  Oct  15  0:00 db2spmlw 0  
ldapdb2  8126712  6029420  Oct  15  1:42 db2hmon 0  
ldapdb2  9699452  7340042  Oct  15  0:12 db2agent (idle) 0  
ldapdb2  10485924  7340042  Oct  15  0:06 db2agent (idle) 0  
LDAP DB2 packages: Home

Sequence: 522  - Command: lslpp -l 'db2*'

#Fileset  Level  PTF Id  State  Type  Description  EFIX Locked 
/usr/lib/objrepos  db2_08_01.cj  8.1.1.80    COMMITTED  Java Common files  
/usr/lib/objrepos  db2_08_01.client  8.1.1.80    COMMITTED  Base Client Support  
/usr/lib/objrepos  db2_08_01.cnvucs  8.1.1.80    COMMITTED  Code Page Conversion Tables - Unicode Support  
/usr/lib/objrepos  db2_08_01.conn  8.1.1.80    COMMITTED  Connect Support  
/usr/lib/objrepos  db2_08_01.conv  8.1.1.80    COMMITTED  Code Page Conversion Tables  
/usr/lib/objrepos  db2_08_01.cs.rte  8.1.1.80    COMMITTED  Communication Support - TCP/IP  
/usr/lib/objrepos  db2_08_01.das  8.1.1.80    COMMITTED  Administration Server  
/usr/lib/objrepos  db2_08_01.db2.engn  8.1.1.80    COMMITTED  Base DB2 UDB Support  
/usr/lib/objrepos  db2_08_01.db2.rte  8.1.1.80    COMMITTED  Run-time Environment  
/usr/lib/objrepos  db2_08_01.db2.samples  8.1.1.80    COMMITTED  Sample Database Source  
/usr/lib/objrepos  db2_08_01.essg  8.1.1.80    COMMITTED  Product Signature for DB2 UDB Enterprise Server Edition  
/usr/lib/objrepos  db2_08_01.icuc  8.1.1.80    COMMITTED  ICU Collation  
/usr/lib/objrepos  db2_08_01.icut  8.1.1.80    COMMITTED  ICU Utilities  
/usr/lib/objrepos  db2_08_01.jdbc  8.1.1.80    COMMITTED  Java Support  
/usr/lib/objrepos  db2_08_01.jhlp.en_US.iso88591  8.1.1.80    COMMITTED  Java Help (HTML) - en_US.iso88591  
/usr/lib/objrepos  db2_08_01.ldap  8.1.1.80    COMMITTED  DB2 LDAP Support  
/usr/lib/objrepos  db2_08_01.msg.en_US.iso88591  8.1.1.80    COMMITTED  Product Messages - en_US.iso88591  
/usr/lib/objrepos  db2_08_01.pext  8.1.1.80    COMMITTED  Parallel Extension  
/usr/lib/objrepos  db2_08_01.repl  8.1.1.80    COMMITTED  Replication  
/usr/lib/objrepos  db2_08_01.sqlproc  8.1.1.80    COMMITTED  SQL Procedures  
LDAP DB2 system logs: Home

Sequence: 523  - Command: ls -l /home/ldapdb2/idsslapd-ldapdb2/logs

Perms  Links  Owner  Group  Size  MM  DD  HH:MM  Filename 
-rw-rw----  ldapdb2  dbsysadm  277599  Jan  31  2014  adminaudit.log 
-rw-rw----  ldapdb2  dbsysadm  Dec  20  2011  audit.log 
-rw-rw----  ldapdb2  dbsysadm  Dec  20  2011  bulkload.log 
-rw-rw----  ldapdb2  dbsysadm  102994  Oct  15  10:32  db2cli.log 
-rw-rw----  ldapdb2  dbsysadm  153  Dec  20  2011  db2clicmds.log 
-rw-rw----  ldapdb2  dbsysadm  455307  Jan  31  2014  ibmdiradm.log 
-rw-rw----  ldapdb2  dbsysadm  2404049  Oct  15  10:32  ibmslapd.log 
-rw-rw----  ldapdb2  dbsysadm  2623  Dec  17  2012  idstools.log 
-rw-rw----  ldapdb2  dbsysadm  Dec  20  2011  lostandfound.log 
-rw-rw----  ldapdb2  dbsysadm  1647  Dec  20  2011  perftune_stat.log 
-rw-rw----  ldapdb2  dbsysadm  Dec  20  2011  traceibmslapd.log 
LDAP DB2 system logs: Home

Sequence: 1523  - Command: find / -name db2diag.log

Filename  Permissions  User  Group  Size 
/home/db2inst1/sqllib/db2dump/db2diag.log  -rw-rw-rw-  db2inst1  db2iadm1  1255174 
/home/ldapdb2/sqllib/db2dump/db2diag.log  -rw-rw-rw-  ldapdb2  dbsysadm  4024846 
LDAP DB2 software configuration: Home

Sequence: 524  - Command: su - ldapdb2 -c db2 get dbm cfg


          Database Manager Configuration

     Node type = Enterprise Server Edition with local and remote clients

 Database manager configuration release level            = 0x0a00

 CPU speed (millisec/instruction)             (CPUSPEED) = 3.857478e-07
 Communications bandwidth (MB/sec)      (COMM_BANDWIDTH) = 1.000000e+02

 Max number of concurrently active databases     (NUMDB) = 8
 Data Links support                          (DATALINKS) = NO
 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) = /usr/java14_64

 Diagnostic error capture level              (DIAGLEVEL) = 3
 Notify Level                              (NOTIFYLEVEL) = 3
 Diagnostic data directory path               (DIAGPATH) = /home/ldapdb2/sqllib/db2dump

 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) = DBSYSADM
 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) = 
 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
 Database manager authentication        (AUTHENTICATION) = SERVER
 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) = /home/ldapdb2

 Database monitor heap size (4KB)          (MON_HEAP_SZ) = 90
 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
 Backup buffer default size (4KB)            (BACKBUFSZ) = 1024
 Restore buffer default size (4KB)           (RESTBUFSZ) = 1024

 Sort heap threshold (4KB)                  (SHEAPTHRES) = 20000

 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) = 2048

 Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10

 Priority of agents                           (AGENTPRI) = SYSTEM
 Max number of existing agents               (MAXAGENTS) = 400
 Agent pool size                        (NUM_POOLAGENTS) = 200(calculated)
 Initial number of agents in pool       (NUM_INITAGENTS) = 0
 Max number of coordinating agents     (MAX_COORDAGENTS) = (MAXAGENTS - NUM_INITAGENTS)
 Max no. of concurrent coordinating agents  (MAXCAGENTS) = MAX_COORDAGENTS
 Max number of client connections      (MAX_CONNECTIONS) = MAX_COORDAGENTS

 Keep fenced process                        (KEEPFENCED) = YES
 Number of pooled fenced processes         (FENCED_POOL) = 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) = p520_aix
 SPM log size                          (SPM_LOG_FILE_SZ) = 256
 SPM resync agent limit                 (SPM_MAX_RESYNC) = 20
 SPM log path                             (SPM_LOG_PATH) = 

 TCP/IP Service name                          (SVCENAME) = ldapdb2svcids
 Discovery mode                               (DISCOVER) = SEARCH
 Discover server instance                (DISCOVER_INST) = ENABLE

 Maximum query degree of parallelism   (MAX_QUERYDEGREE) = ANY
 Enable intra-partition parallelism     (INTRA_PARALLEL) = NO

 No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 4096
 Number of FCM request blocks              (FCM_NUM_RQB) = AUTOMATIC
 Number of FCM connection entries      (FCM_NUM_CONNECT) = AUTOMATIC
 Number of FCM message anchors         (FCM_NUM_ANCHORS) = AUTOMATIC

 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

		
LDAP DB2 active databases: Home

Sequence: 525  - Command: su - ldapdb2 -c db2 LIST ACTIVE DATABASES

SQL1611W  No data was returned by Database System Monitor.  SQLSTATE=00000
		
LDAP DB2 database entries: Home

Sequence: 526  - Command: su - ldapdb2 -c db2

(c) Copyright IBM Corporation 1993,2002
Command Line Processor for DB2 SDK 8.2.1

You can issue database manager commands and SQL statements from the command 
prompt. For example:
    db2 => connect to sample
    db2 => bind sample.bnd

For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
 ? CATALOG DATABASE for help on the CATALOG DATABASE command
 ? CATALOG          for help on all of the CATALOG commands.

To exit db2 interactive mode, type QUIT at the command prompt. Outside 
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.

For more detailed help, refer to the Online Reference Manual.

db2 => db2 => 
   Database Connection Information

 Database server        = DB2/AIX64 8.2.1
 SQL authorization ID   = LDAPDB2
 Local database alias   = LDAPDB2

db2 => 
EID         DN_TRUNC                                                                                          
----------- --------------------------------------------------------------------------------------------------
          2 CN=LOCALHOST                                                                                      
          3 CN=IBMPOLICIES                                                                                    
         10 O=BLUEFINCH                                                                                       
         74 CN=AIXDATA                                                                                        
          7 CN=REPLICATION,CN=LOCALHOST                                                                       
          9 CN=CRYPTO,CN=LOCALHOST                                                                            
          4 IBM-REPLICAGROUP=DEFAULT,CN=IBMPOLICIES                                                           
          5 GLOBALGROUPNAME=GLOBALADMINGROUP,CN=IBMPOLICIES                                                   
          6 CN=PWDPOLICY,CN=IBMPOLICIES                                                                       
          8 CN=REPLICATION,CN=IBMPOLICIES                                                                     
        160 OU=SUDOERS,CN=IBMPOLICIES                                                                         
         11 OU=PEOPLE,O=BLUEFINCH                                                                             
         40 OU=GROUPS,O=BLUEFINCH                                                                             
         71 OU=SYSTEM,O=BLUEFINCH                                                                             
        138 CN=ROLES,O=BLUEFINCH                                                                              
        139 CN=ADMINS,O=BLUEFINCH                                                                             
        140 CN=ADMINGROUP,O=BLUEFINCH                                                                         
        141 CN=ADMINSMGR,O=BLUEFINCH                                                                          
         12 UID=DAEMON,OU=PEOPLE,O=BLUEFINCH                                                                  
         13 UID=BIN,OU=PEOPLE,O=BLUEFINCH                                                                     
         14 UID=SYS,OU=PEOPLE,O=BLUEFINCH                                                                     
         15 UID=ADM,OU=PEOPLE,O=BLUEFINCH                                                                     
         17 UID=NOBODY,OU=PEOPLE,O=BLUEFINCH                                                                  
         18 UID=LPD,OU=PEOPLE,O=BLUEFINCH                                                                     
         19 UID=LP,OU=PEOPLE,O=BLUEFINCH                                                                      
         20 UID=INVSCOUT,OU=PEOPLE,O=BLUEFINCH                                                                
         21 UID=SNAPP,OU=PEOPLE,O=BLUEFINCH                                                                   
         22 UID=IPSEC,OU=PEOPLE,O=BLUEFINCH                                                                   
         24 UID=SSHD,OU=PEOPLE,O=BLUEFINCH                                                                    
         25 UID=SFTP,OU=PEOPLE,O=BLUEFINCH                                                                    
         26 UID=KEYTEST,OU=PEOPLE,O=BLUEFINCH                                                                 
         27 UID=WAS,OU=PEOPLE,O=BLUEFINCH                                                                     
         28 UID=GA0112,OU=PEOPLE,O=BLUEFINCH                                                                  
         29 UID=ESAADMIN,OU=PEOPLE,O=BLUEFINCH                                                                
         30 UID=ANDREW,OU=PEOPLE,O=BLUEFINCH                                                                  
         31 UID=CO1217,OU=PEOPLE,O=BLUEFINCH                                                                  
         32 UID=MQM,OU=PEOPLE,O=BLUEFINCH                                                                     
         33 UID=ANDREW2,OU=PEOPLE,O=BLUEFINCH                                                                 
         34 UID=PCONSOLE,OU=PEOPLE,O=BLUEFINCH                                                                
         35 UID=RADIUSD,OU=PEOPLE,O=BLUEFINCH                                                                 
         36 UID=IDSLDAP,OU=PEOPLE,O=BLUEFINCH                                                                 
         37 UID=WWW,OU=PEOPLE,O=BLUEFINCH                                                                     
         38 UID=WWWADM,OU=PEOPLE,O=BLUEFINCH                                                                  
         39 UID=LDAPDB2,OU=PEOPLE,O=BLUEFINCH                                                                 
        167 UID=TEST,OU=PEOPLE,O=BLUEFINCH                                                                    
         41 CN=SYSTEM,OU=GROUPS,O=BLUEFINCH                                                                   
         42 CN=STAFF,OU=GROUPS,O=BLUEFINCH                                                                    
         43 CN=BIN,OU=GROUPS,O=BLUEFINCH                                                                      
         44 CN=SYS,OU=GROUPS,O=BLUEFINCH                                                                      
         45 CN=ADM,OU=GROUPS,O=BLUEFINCH                                                                      
         47 CN=MAIL,OU=GROUPS,O=BLUEFINCH                                                                     
         48 CN=SECURITY,OU=GROUPS,O=BLUEFINCH                                                                 
         49 CN=CRON,OU=GROUPS,O=BLUEFINCH                                                                     
         50 CN=PRINTQ,OU=GROUPS,O=BLUEFINCH                                                                   
         51 CN=AUDIT,OU=GROUPS,O=BLUEFINCH                                                                    
         52 CN=ECS,OU=GROUPS,O=BLUEFINCH                                                                      
         53 CN=NOBODY,OU=GROUPS,O=BLUEFINCH                                                                   
         54 CN=USR,OU=GROUPS,O=BLUEFINCH                                                                      
         55 CN=PERF,OU=GROUPS,O=BLUEFINCH                                                                     
         56 CN=SHUTDOWN,OU=GROUPS,O=BLUEFINCH                                                                 
         57 CN=LP,OU=GROUPS,O=BLUEFINCH                                                                       
         58 CN=INVSCOUT,OU=GROUPS,O=BLUEFINCH                                                                 
         59 CN=SNAPP,OU=GROUPS,O=BLUEFINCH                                                                    
         60 CN=IPSEC,OU=GROUPS,O=BLUEFINCH                                                                    
         61 CN=SFTP,OU=GROUPS,O=BLUEFINCH                                                                     
         62 CN=SSHD,OU=GROUPS,O=BLUEFINCH                                                                     
         63 CN=WASGRP,OU=GROUPS,O=BLUEFINCH                                                                   
         64 CN=MQM,OU=GROUPS,O=BLUEFINCH                                                                      
         65 CN=PCONSOLE,OU=GROUPS,O=BLUEFINCH                                                                 
         66 CN=RADIUSD,OU=GROUPS,O=BLUEFINCH                                                                  
         67 CN=PTSC,OU=GROUPS,O=BLUEFINCH                                                                     
         68 CN=IDSLDAP,OU=GROUPS,O=BLUEFINCH                                                                  
         69 CN=WWW,OU=GROUPS,O=BLUEFINCH                                                                      
         70 CN=DBSYSADM,OU=GROUPS,O=BLUEFINCH                                                                 
         72 CN=AIXID,OU=SYSTEM,O=BLUEFINCH                                                                    
         73 CN=AIXBASEID,OU=SYSTEM,O=BLUEFINCH                                                                
         75 OU=PEOPLE,CN=AIXDATA                                                                              
        104 OU=GROUPS,CN=AIXDATA                                                                              
        135 OU=SYSTEM,CN=AIXDATA                                                                              
         76 UID=DAEMON,OU=PEOPLE,CN=AIXDATA                                                                   
         77 UID=BIN,OU=PEOPLE,CN=AIXDATA                                                                      
         78 UID=SYS,OU=PEOPLE,CN=AIXDATA                                                                      
         79 UID=ADM,OU=PEOPLE,CN=AIXDATA                                                                      
         80 UID=UUCP,OU=PEOPLE,CN=AIXDATA                                                                     
         81 UID=INVSCOUT,OU=PEOPLE,CN=AIXDATA                                                                 
         82 UID=NUUCP,OU=PEOPLE,CN=AIXDATA                                                                    
         83 UID=ESAADMIN,OU=PEOPLE,CN=AIXDATA                                                                 
         84 UID=LPD,OU=PEOPLE,CN=AIXDATA                                                                      
         85 UID=SSHD,OU=PEOPLE,CN=AIXDATA                                                                     
         86 UID=LP,OU=PEOPLE,CN=AIXDATA                                                                       
         87 UID=CO1217,OU=PEOPLE,CN=AIXDATA                                                                   
         88 UID=PCONSOLE,OU=PEOPLE,CN=AIXDATA                                                                 
         89 UID=SNAPP,OU=PEOPLE,CN=AIXDATA                                                                    
         90 UID=IPSEC,OU=PEOPLE,CN=AIXDATA                                                                    
         91 UID=KEYTEST,OU=PEOPLE,CN=AIXDATA                                                                  
         92 UID=WAS,OU=PEOPLE,CN=AIXDATA                                                                      
         93 UID=GA0112,OU=PEOPLE,CN=AIXDATA                                                                   
         94 UID=ANDREW,OU=PEOPLE,CN=AIXDATA                                                                   
         95 UID=MQM,OU=PEOPLE,CN=AIXDATA                                                                      
         96 UID=ANDREW2,OU=PEOPLE,CN=AIXDATA                                                                  
         97 UID=RADIUSD,OU=PEOPLE,CN=AIXDATA                                                                  
         98 UID=IDSLDAP,OU=PEOPLE,CN=AIXDATA                                                                  
         99 UID=WWW,OU=PEOPLE,CN=AIXDATA                                                                      
        100 UID=WWWADM,OU=PEOPLE,CN=AIXDATA                                                                   
        101 UID=LDAPDB2,OU=PEOPLE,CN=AIXDATA                                                                  
        102 UID=SFTP,OU=PEOPLE,CN=AIXDATA                                                                     
        103 UID=NOBODY,OU=PEOPLE,CN=AIXDATA                                                                   
        105 CN=SYSTEM,OU=GROUPS,CN=AIXDATA                                                                    
        106 CN=STAFF,OU=GROUPS,CN=AIXDATA                                                                     
        107 CN=BIN,OU=GROUPS,CN=AIXDATA                                                                       
        108 CN=SYS,OU=GROUPS,CN=AIXDATA                                                                       
        109 CN=ADM,OU=GROUPS,CN=AIXDATA                                                                       
        110 CN=UUCP,OU=GROUPS,CN=AIXDATA                                                                      
        111 CN=MAIL,OU=GROUPS,CN=AIXDATA                                                                      
        112 CN=SECURITY,OU=GROUPS,CN=AIXDATA                                                                  
        113 CN=CRON,OU=GROUPS,CN=AIXDATA                                                                      
        114 CN=PRINTQ,OU=GROUPS,CN=AIXDATA                                                                    
        115 CN=AUDIT,OU=GROUPS,CN=AIXDATA                                                                     
        116 CN=LP,OU=GROUPS,CN=AIXDATA                                                                        
        117 CN=INVSCOUT,OU=GROUPS,CN=AIXDATA                                                                  
        118 CN=SNAPP,OU=GROUPS,CN=AIXDATA                                                                     
        119 CN=PCONSOLE,OU=GROUPS,CN=AIXDATA                                                                  
        120 CN=SSHD,OU=GROUPS,CN=AIXDATA                                                                      
        121 CN=DBSYSADM,OU=GROUPS,CN=AIXDATA                                                                  
        122 CN=PERF,OU=GROUPS,CN=AIXDATA                                                                      
        123 CN=SHUTDOWN,OU=GROUPS,CN=AIXDATA                                                                  
        124 CN=ECS,OU=GROUPS,CN=AIXDATA                                                                       
        125 CN=USR,OU=GROUPS,CN=AIXDATA                                                                       
        126 CN=SFTP,OU=GROUPS,CN=AIXDATA                                                                      
        127 CN=IPSEC,OU=GROUPS,CN=AIXDATA                                                                     
        128 CN=WASGRP,OU=GROUPS,CN=AIXDATA                                                                    
        129 CN=MQM,OU=GROUPS,CN=AIXDATA                                                                       
        130 CN=RADIUSD,OU=GROUPS,CN=AIXDATA                                                                   
        131 CN=PTSC,OU=GROUPS,CN=AIXDATA                                                                      
        132 CN=IDSLDAP,OU=GROUPS,CN=AIXDATA                                                                   
        133 CN=WWW,OU=GROUPS,CN=AIXDATA                                                                       
        134 CN=NOBODY,OU=GROUPS,CN=AIXDATA                                                                    
        136 CN=AIXID,OU=SYSTEM,CN=AIXDATA                                                                     
        137 CN=AIXBASEID,OU=SYSTEM,CN=AIXDATA                                                                 
        170 CN=UPTIME,OU=SUDOERS,CN=IBMPOLICIES                                                               
        169 CN=ANDREW,OU=SUDOERS,CN=IBMPOLICIES                                                               
        163 CN=DEFAULTS,OU=SUDOERS,CN=IBMPOLICIES                                                             
        164 CN=ROOT,OU=SUDOERS,CN=IBMPOLICIES                                                                 
        165 CN=TEST,OU=SUDOERS,CN=IBMPOLICIES                                                                 

  144 record(s) selected.

db2 => db2 => 
		
LDAP DB2 database directory: Home

Sequence: 527  - Command: su - ldapdb2 -c db2 list database directory

  
System Database Directory  
  
Number of entries in the directory  
  
Database 1 entry:  
  
Database alias   LDAPDB2B 
Database name   LDAPDB2 
Node name   LDAPDB2N 
Database release level   a.00 
Comment   
Directory entry type   Remote 
Authentication   SERVER 
Catalog database partition number   -1 
Alternate server hostname   
Alternate server port number   
  
Database 2 entry:  
  
Database alias   LDAPDB2 
Database name   LDAPDB2 
Local database directory   /home/ldapdb2 
Database release level   a.00 
Comment   
Directory entry type   Indirect 
Catalog database partition number  
Alternate server hostname   
Alternate server port number   
  
LDAP DB2 database configuration: Home

Sequence: 528  - Command: su - ldapdb2 -c db2 get database configuration for LDAPDB2


       Database Configuration for Database LDAPDB2

 Database configuration release level                    = 0x0a00
 Database release level                                  = 0x0a00

 Database territory                                      = US
 Database code page                                      = 1208
 Database code set                                       = UTF-8
 Database country/region code                            = 1
 Database collating sequence                             = BINARY
 Alternate collating sequence              (ALT_COLLATE) = 

 Dynamic SQL Query management           (DYN_QUERY_MGMT) = DISABLE

 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
 Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
 Number of frequent values retained     (NUM_FREQVALUES) = 10
 Number of quantiles retained            (NUM_QUANTILES) = 20

 Backup pending                                          = NO

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

 Multi-page file allocation enabled                      = YES

 Log retain for recovery status                          = NO
 User exit for logging status                            = NO

 Data Links Token Expiry Interval (sec)      (DL_EXPINT) = 60
 Data Links Write Token Init Expiry Intvl(DL_WT_IEXPINT) = 60
 Data Links Number of Copies             (DL_NUM_COPIES) = 1
 Data Links Time after Drop (days)        (DL_TIME_DROP) = 1
 Data Links Token in Uppercase                (DL_UPPER) = NO
 Data Links Token Algorithm                   (DL_TOKEN) = MAC0

 Database heap (4KB)                            (DBHEAP) = 1200
 Size of database shared memory (4KB)  (DATABASE_MEMORY) = AUTOMATIC
 Catalog cache size (4KB)              (CATALOGCACHE_SZ) = (MAXAPPLS*4)
 Log buffer size (4KB)                        (LOGBUFSZ) = 8
 Utilities heap size (4KB)                (UTIL_HEAP_SZ) = 5000
 Buffer pool size (pages)                     (BUFFPAGE) = 1000
 Extended storage segments size (4KB)    (ESTORE_SEG_SZ) = 16000
 Number of extended storage segments   (NUM_ESTORE_SEGS) = 0
 Max storage for lock list (4KB)              (LOCKLIST) = 100

 Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 30000
 Percent of mem for appl. group heap   (GROUPHEAP_RATIO) = 70
 Max appl. control heap size (4KB)     (APP_CTL_HEAP_SZ) = 128

 Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = (SHEAPTHRES)
 Sort list heap (4KB)                         (SORTHEAP) = 256
 SQL statement heap (4KB)                     (STMTHEAP) = 4096
 Default application heap (4KB)             (APPLHEAPSZ) = 1280
 Package cache size (4KB)                   (PCKCACHESZ) = 360
 Statistics heap size (4KB)               (STAT_HEAP_SZ) = 4384

 Interval for checking deadlock (ms)         (DLCHKTIME) = 10000
 Percent. of lock lists per application       (MAXLOCKS) = 10
 Lock timeout (sec)                        (LOCKTIMEOUT) = -1

 Changed pages threshold                (CHNGPGS_THRESH) = 60
 Number of asynchronous page cleaners   (NUM_IOCLEANERS) = 1
 Number of I/O servers                   (NUM_IOSERVERS) = 3
 Index sort flag                             (INDEXSORT) = YES
 Sequential detect flag                      (SEQDETECT) = YES
 Default prefetch size (pages)         (DFT_PREFETCH_SZ) = AUTOMATIC

 Track modified pages                         (TRACKMOD) = OFF

 Default number of containers                            = 1
 Default tablespace extentsize (pages)   (DFT_EXTENT_SZ) = 32

 Max number of active applications            (MAXAPPLS) = AUTOMATIC
 Average number of active applications       (AVG_APPLS) = 1
 Max DB files open per application            (MAXFILOP) = 64

 Log file size (4KB)                         (LOGFILSIZ) = 2000
 Number of primary log files                (LOGPRIMARY) = 3
 Number of secondary log files               (LOGSECOND) = 2
 Changed path to log files                  (NEWLOGPATH) = 
 Path to log files                                       = /home/ldapdb2/ldapdb2/NODE0000/SQL00001/SQLOGDIR/
 Overflow log path                     (OVERFLOWLOGPATH) = 
 Mirror log path                         (MIRRORLOGPATH) = 
 First active log file                                   = 
 Block log on disk full                (BLK_LOG_DSK_FUL) = NO
 Percent of max active log space by transaction(MAX_LOG) = 0
 Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0

 Group commit count                          (MINCOMMIT) = 1
 Percent log file reclaimed before soft chckpt (SOFTMAX) = 100
 Log retain for recovery enabled             (LOGRETAIN) = OFF
 User exit for logging enabled                (USEREXIT) = OFF

 HADR database role                                      = STANDARD
 HADR local host name                  (HADR_LOCAL_HOST) = 
 HADR local service name                (HADR_LOCAL_SVC) = 
 HADR remote host name                (HADR_REMOTE_HOST) = 
 HADR remote service name              (HADR_REMOTE_SVC) = 
 HADR instance name of remote server  (HADR_REMOTE_INST) = 
 HADR timeout value                       (HADR_TIMEOUT) = 120
 HADR log write synchronization mode     (HADR_SYNCMODE) = NEARSYNC

 First log archive method                 (LOGARCHMETH1) = OFF
 Options for logarchmeth1                  (LOGARCHOPT1) = 
 Second log archive method                (LOGARCHMETH2) = OFF
 Options for logarchmeth2                  (LOGARCHOPT2) = 
 Failover log archive path                (FAILARCHPATH) = 
 Number of log archive retries on error   (NUMARCHRETRY) = 5
 Log archive retry Delay (secs)         (ARCHRETRYDELAY) = 20
 Vendor options                              (VENDOROPT) = 

 Auto restart enabled                      (AUTORESTART) = ON
 Index re-creation time and redo index build  (INDEXREC) = SYSTEM (RESTART)
 Log pages during index build            (LOGINDEXBUILD) = OFF
 Default number of loadrec sessions    (DFT_LOADREC_SES) = 1
 Number of database backups to retain   (NUM_DB_BACKUPS) = 12
 Recovery history retention (days)     (REC_HIS_RETENTN) = 366

 TSM management class                    (TSM_MGMTCLASS) = 
 TSM node name                            (TSM_NODENAME) = 
 TSM owner                                   (TSM_OWNER) = 
 TSM password                             (TSM_PASSWORD) = 

 Automatic maintenance                      (AUTO_MAINT) = OFF
   Automatic database backup            (AUTO_DB_BACKUP) = OFF
   Automatic table maintenance          (AUTO_TBL_MAINT) = OFF
     Automatic runstats                  (AUTO_RUNSTATS) = OFF
     Automatic statistics profiling    (AUTO_STATS_PROF) = OFF
       Automatic profile updates         (AUTO_PROF_UPD) = OFF
     Automatic reorganization               (AUTO_REORG) = OFF


		
List active databases: Home

Sequence: 529  - Command: su - ldapdb2 -c db2ilist

ldapdb2
		
Tivoli Directory Server: Home

Sequence: 1529  - Command: dsilist

/usr/local/bin/syscheck[728]: dsilist:  not found.
		
DB2 software level: Home

Sequence: 530  - Command: su - ldapdb2 -c db2level

DB21085I  Instance "ldapdb2" uses "64" bits and DB2 code release "SQL08021" 
with level identifier "03020106".
Informational tokens are "DB2 v8.1.1.80", "s041221", "U800400", and FixPak "8".
Product is installed at "/usr/opt/db2_08_01".

		
Find DB2 Licences: Home

Sequence: 1530  - Command: su - nagios -c "~/sqllib/adm/db2licm -l"

DB2 user: ldapdb2
Product Name                            = "DB2 Enterprise Server Edition"
Product Identifier                      = "DB2ESE"
Version Information                     = "8.2"
Expiry Date                             = "Permanent"
Registered Connect User Policy          = "Disabled"
Number Of Entitled Connect Users        = "5"
Enforcement Policy                      = "Soft Stop"
Number of processors                    = "2"
Number of licensed processors           = "101"
Database partitioning feature           = "Not entitled"
Annotation                              = ""
Other information                       = ""

Product Name                            = "DB2 High Availability Disaster Recovery Option"
Product Identifier                      = "DB2HADR"
Version Information                     = "8.2"
Expiry Date                             = "Permanent"
Annotation                              = ""
Other information                       = ""

Product Name                            = "DB2 Advanced Security Option"
Product Identifier                      = "DB2ASO"
Version Information                     = "8.2"
Expiry Date                             = "Permanent"
Annotation                              = ""
Other information                       = ""

 
DB2 user: db2inst1
[YOU HAVE NEW MAIL]
Product name:                     "DB2 Workgroup Server Edition"
Expiry date:                      "Expired"
Product identifier:               "db2wse"
Version information:              "9.7"
Max number of Value Units:        "480"
Max amount of memory (GB):        "64"
Enforcement policy:               "Soft Stop"

Product name:                     "DB2 Connect Server"
Expiry date:                      "Expired"
Product identifier:               "db2consv"
Version information:              "9.7"
Concurrent connect user policy:   "Disabled"
Enforcement policy:               "Soft Stop"



 
DB2 user: db2fenc1
 
		
Find DB2 software levels: Home

Sequence: 1531  - Command: su - -c "~/sqllib/bin/db2level"

DB2 user: ldapdb2
DB21085I  Instance "ldapdb2" uses "64" bits and DB2 code release "SQL08021" 
with level identifier "03020106".
Informational tokens are "DB2 v8.1.1.80", "s041221", "U800400", and FixPak "8".
Product is installed at "/usr/opt/db2_08_01".

 
DB2 user: db2inst1
[YOU HAVE NEW MAIL]
DB21085I  Instance "db2inst1" uses "64" bits and DB2 code release "SQL09075" 
with level identifier "08060107".
Informational tokens are "DB2 v9.7.0.5", "s111017", "IP23285", and Fix Pack 
"5".
Product is installed at "/opt/IBM/db2/V9.7_01".

 
DB2 user: db2fenc1
 
		
Find DB2 instances: Home

Sequence: 1532  - Command: su - -c "~/sqllib/bin/db2ilist"

DB2 user: ldapdb2
ldapdb2
 
DB2 user: db2inst1
[YOU HAVE NEW MAIL]
db2inst1
 
DB2 user: db2fenc1
 
		
Find DB2 database instances: Home

Sequence: 1533  - Command: su - -c "~/sqllib/bin/db2 GET INSTANCE"

DB2 user: ldapdb2

 The current database manager instance is:  ldapdb2

 
DB2 user: db2inst1
[YOU HAVE NEW MAIL]

 The current database manager instance is:  db2inst1

 
DB2 user: db2fenc1
 
		
Find DB2 databases: Home

Sequence: 1534  - Command: su - -c "~/sqllib/bin/db2 LIST DATABASE DIRECTORY"

DB2 user: ldapdb2

 System Database Directory

 Number of entries in the directory = 2

Database 1 entry:

 Database alias                       = LDAPDB2B
 Database name                        = LDAPDB2
 Node name                            = LDAPDB2N
 Database release level               = a.00
 Comment                              =
 Directory entry type                 = Remote
 Authentication                       = SERVER
 Catalog database partition number    = -1
 Alternate server hostname            =
 Alternate server port number         =

Database 2 entry:

 Database alias                       = LDAPDB2
 Database name                        = LDAPDB2
 Local database directory             = /home/ldapdb2
 Database release level               = a.00
 Comment                              =
 Directory entry type                 = Indirect
 Catalog database partition number    = 0
 Alternate server hostname            =
 Alternate server port number         =

 
DB2 user: db2inst1
[YOU HAVE NEW MAIL]

 System Database Directory

 Number of entries in the directory = 2

Database 1 entry:

 Database alias                       = TOOLSDB
 Database name                        = TOOLSDB
 Local database directory             = /home/db2inst1
 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                       = SAMPLE
 Database name                        = SAMPLE
 Local database directory             = /home/db2inst1
 Database release level               = d.00
 Comment                              =
 Directory entry type                 = Indirect
 Catalog database partition number    = 0
 Alternate server hostname            =
 Alternate server port number         =

 
DB2 user: db2fenc1
 
		
Find active DB2 databases: Home

Sequence: 1535  - Command: su - -c "~/sqllib/bin/db2 LIST ACTIVE DATABASES"

DB2 user: ldapdb2

                           Active Databases

Database name                              = LDAPDB2
Applications connected currently           = 1
Database path                              = /home/ldapdb2/ldapdb2/NODE0000/SQL00001/

 
DB2 user: db2inst1
[YOU HAVE NEW MAIL]
SQL1032N  No start database manager command was issued.  SQLSTATE=57019
 
DB2 user: db2fenc1
 
		

Licenced to: BlueFinch BV - sales@bluefinch.nl

Return to homepage