Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

DB2 Partitioned Database Crashes After ~10 Minutes

Posted on 2007-10-04
13
Medium Priority
?
1,714 Views
Last Modified: 2012-05-05
Hi all,

I wanted to learn about partitioned database environments, so I downloaded an evaluation copy of DB2v9 ESE.  I created a single partition database without a problem, but when I create a database with more than one partition (I've only tried up to two partitions), the instance will run for about 5-10 minutes, then the instance will crash.  I can't figure out why.  It will only crash after I connected to at least once.

I am installing it on a Ubuntu 7.04 (Feisty) system.  Specs are:

- Intel Hyper-threaded 3.0GHz (functions as 2 CPUs)
- 2GB RAM

Here's some more info about my system:

      $ ipcs -l

      ------ Shared Memory Limits --------
      max number of segments = 4096
      max seg size (kbytes) = 2097152
      max total shared memory (pages) = 2097152
      min seg size (bytes) = 1

      ------ Semaphore Limits --------
      max number of arrays = 1024
      max semaphores per array = 250
      max semaphores system wide = 256000
      max ops per semop call = 32
      semaphore max value = 32767

      ------ Messages: Limits --------
      max queues system wide = 1024
      max size of message (bytes) = 8192
      default max size of queue (bytes) = 16384

The only additions I made to /etc/sysctl.conf are:

      kernel.msgmni = 1024
      kernel.sem = 250 256000 32 1024

db2nodes.cfg contains:

      0 slnx 0
      1 slnx 1

As you can see I am able to start the instance:

      $ db2start
      10/04/2007 09:25:21     1   0   SQL1063N  DB2START processing was successful.
      10/04/2007 09:25:21     0   0   SQL1063N  DB2START processing was successful.
      SQL1063N  DB2START processing was successful.

I then created the SAMPLE database without a problem.

So, like I said, after 5-10 minutes, the instance will just stop.  A LOT of files will be created in ~/sqllib/db2dump, and A LOT of entries are made in db2diag.log.

$ ls ~/sqllib/db2dump
92252988799680.000  a9291.000               db2cos9271-130616761.0  db2cos9311-130616761.0  t9180.001  t9272.000
92752988799680.000  c9180.001               db2cos9272-130616761.0  db2diag.log             t9181.000  t9275.000
92912988799680.000  c9181.000               db2cos9275-130616761.0  db2eventlog.000         t9188.000  t9291.000
93072988799680.000  db2cos9180-130639289.1  db2cos9291-130616761.0  db2eventlog.000.crash   t9190.000  t9294.000
93092988799680.000  db2cos9181-130616761.0  db2cos9294-130616761.0  db2eventlog.001.crash   t9225.000  t9306.000
a9225.000           db2cos9188-130616761.0  db2cos9306-130616761.0  dbtest.nfy              t9271.000  t9311.000

Here's the first 80 lines of db2diag.log (it was deleted after instance was started, so it only contains data from when the crash starts):

2007-10-04-09.35.21.872491-240 I1G1267            LEVEL: Event
PID     : 9180                 TID  : 2988574400  PROC : db2sysc 1
INSTANCE: dbtest               NODE : 001
FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120
START   : New Diagnostic Log file
DATA #1 : Build Level, 128 bytes
Instance "dbtest" uses "32" bits and DB2 code release "SQL09010"
with level identifier "02010107".
Informational tokens are "DB2 v9.1.0.0", "s060629", "LINUXIA32", Fix Pack "0".
DATA #2 : System Info, 436 bytes
System: Linux slnx 6 2 i686
CPU: total:2 online:2 Cores per socket:1 Threading degree per core:2
Physical Memory(MB): total:2027 free:67
Virtual  Memory(MB): total:12884 free:10891
Swap     Memory(MB): total:10857 free:10824
Kernel   Params: msgMaxMessageSize:8192 msgMsgMap:16384 msgMaxQueueIDs:1024
                 msgNumberOfHeaders:16384 msgMaxQueueSize:16384
                 msgMaxSegmentSize:16 shmMax:2147483648 shmMin:1 shmIDs:4096
                 shmSegments:4096 semMap:256000 semIDs:1024 semNum:256000
                 semUndo:256000 semNumPerID:250 semOps:32 semUndoSize:20
                 semMaxVal:32767 semAdjustOnExit:32767
Information in this record is only valid at the time when this file was
created (see this record's time stamp)

2007-10-04-09.35.21.872395-240 I1269G338          LEVEL: Event
PID     : 9180                 TID  : 2988574400  PROC : db2sysc 1
INSTANCE: dbtest               NODE : 001
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:10
START   : Invoking /home/dbtest/sqllib/bin/db2cos from oper system services sqloEDUCodeTrapHandler

2007-10-04-09.35.27.885953-240 I1608G299          LEVEL: Event
PID     : 9180                 TID  : 2988574400  PROC : db2sysc 1
INSTANCE: dbtest               NODE : 001
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:20
STOP    : Completed invoking /home/dbtest/sqllib/bin/db2cos

2007-10-04-09.35.27.886913-240 E1908G511          LEVEL: Severe
PID     : 9180                 TID  : 2988574400  PROC : db2sysc 1
INSTANCE: dbtest               NODE : 001
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
MESSAGE : ADM0503C  An unexpected internal processing error has occurred.  ALL
          DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
          Diagnostic information has been recorded.  Contact IBM Support for
          further assistance.

2007-10-04-09.35.27.887088-240 E2420G905          LEVEL: Severe
PID     : 9180                 TID  : 2988574400  PROC : db2sysc 1
INSTANCE: dbtest               NODE : 001
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:20
DATA #1 : Signal Number Recieved, 4 bytes
11
DATA #2 : Siginfo, 128 bytes
0xBFBC0A9C : 0B00 0000 0000 0000 0100 0000 6586 AA5B    ............e..[
0xBFBC0AAC : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFBC0ABC : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFBC0ACC : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFBC0ADC : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFBC0AEC : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFBC0AFC : 0000 0000 F43F F8B7 0000 0000 0E00 0000    .....?..........
0xBFBC0B0C : 240B BCBF C3D7 F7B7 0E00 0000 C80B BCBF    $...............

2007-10-04-09.35.27.891235-240 E3326G507          LEVEL: Severe
PID     : 9176                 TID  : 2988574400  PROC : db2wdog 1 1
INSTANCE: dbtest               NODE : 001
FUNCTION: DB2 UDB, oper system services, sqloWatchDogMain, probe:20
MESSAGE : ADM0503C  An unexpected internal processing error has occurred.  ALL
          DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
          Diagnostic information has been recorded.  Contact IBM Support for
          further assistance.

2007-10-04-09.35.27.891587-240 I3834G335          LEVEL: Severe
PID     : 9176                 TID  : 2988574400  PROC : db2wdog 1 1
INSTANCE: dbtest               NODE : 001
FUNCTION: DB2 UDB, oper system services, sqloWatchDogMain, probe:20
DATA #1 : Hexdump, 8 bytes
0xBFBC2038 : 0101 0000 0B00 0000                        ........

2007-10-04-09.35.27.905191-240 I4170G332          LEVEL: Severe
PID     : 9176                 TID  : 2988574400  PROC : db2wdog 1 1


Any ideas?
0
Comment
Question by:ocgstyles
12 Comments
 
LVL 46

Expert Comment

by:Kent Olsen
ID: 20014434
Hi ocgstyles,

It's hard to tell if this is a configuration mismatch or DB2 bug, but the message clearly indicates that DB2 trapped itself and shut down.

One other possibility is, of course, that partitioning has been crippled in the free version of UDB, but I don't know.


If you've got time, try installed UDB V8 and repeating the test.  V8 and V9 are radically different in structure so the only lesson to be learned is whether the free copy of V8 will actually run a partitioned database.


Good Luck,
Kent
0
 
LVL 5

Author Comment

by:ocgstyles
ID: 20017567
Hi Kent,

I wasn't able to find a download for that on IBM's website, but I managed to find a copy at work.  Luckily I found a disc for v8.1.  Too bad when I tried installing that, I failed a lot of dependencies.  I don't know if its worth ironing those out or not.  
0
 
LVL 13

Expert Comment

by:ghp7000
ID: 20021393
you need to post the dbm cfg settings as well as the db settings for each node as well as all the db2set parameters. I suspect that kdo's reasoning is correct, the free version is for one and only one connection, therefore if you have more than one agent per node, it may shutdown and in a partitioned environment, you need at least two agents per connection.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
LVL 5

Author Comment

by:ocgstyles
ID: 20022442
Here's all the configurations.  I haven't adjusted any settings in either dbm cfg of db cfg; they are all default.


$ db2 get dbm cfg

          Database Manager Configuration

     Node type = Enterprise Server Edition with local and remote clients

 Database manager configuration release level            = 0x0b00

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

 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) = /home/dbtest/sqllib/java/jdk32

 Diagnostic error capture level              (DIAGLEVEL) = 3
 Notify Level                              (NOTIFYLEVEL) = 3
 Diagnostic data directory path               (DIAGPATH) = /home/dbtest/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) = DBTEST
 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/dbtest

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

 Maximum Asynchronous TQs per query    (FEDERATED_ASYNC) = 0

 No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC
 No. of int. communication channels   (FCM_NUM_CHANNELS) = 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



=======================================================================
=======================================================================
=======================================================================




$ db2_all db2 get db cfg for sample


       Database Configuration for Database sample

 Database configuration release level                    = 0x0b00
 Database release level                                  = 0x0b00

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

 Dynamic SQL Query management           (DYN_QUERY_MGMT) = DISABLE

 Discovery support for this database       (DISCOVER_DB) = ENABLE

 Restrict access                                         = NO
 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

 Self tuning memory                    (SELF_TUNING_MEM) = OFF
 Size of database shared memory (4KB)  (DATABASE_MEMORY) = COMPUTED
 Database memory threshold               (DB_MEM_THRESH) = 10
 Max storage for lock list (4KB)              (LOCKLIST) = 100
 Percent. of lock lists per application       (MAXLOCKS) = 10
 Package cache size (4KB)                   (PCKCACHESZ) = (MAXAPPLS*8)
 Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 5000
 Sort list heap (4KB)                         (SORTHEAP) = 256

 Database heap (4KB)                            (DBHEAP) = 1200
 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
 Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 40000
 Percent of mem for appl. group heap   (GROUPHEAP_RATIO) = 70
 Max appl. control heap size (4KB)     (APP_CTL_HEAP_SZ) = 512

 SQL statement heap (4KB)                     (STMTHEAP) = 2048
 Default application heap (4KB)             (APPLHEAPSZ) = 64
 Statistics heap size (4KB)               (STAT_HEAP_SZ) = 4384

 Interval for checking deadlock (ms)         (DLCHKTIME) = 10000
 Lock timeout (sec)                        (LOCKTIMEOUT) = -1

 Changed pages threshold                (CHNGPGS_THRESH) = 60
 Number of asynchronous page cleaners   (NUM_IOCLEANERS) = AUTOMATIC
 Number of I/O servers                   (NUM_IOSERVERS) = AUTOMATIC
 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) = AUTOMATIC
 Max DB files open per application            (MAXFILOP) = 64

 Log file size (4KB)                         (LOGFILSIZ) = 1000
 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/dbtest/dbtest/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 max primary 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) = ON
   Automatic database backup            (AUTO_DB_BACKUP) = OFF
   Automatic table maintenance          (AUTO_TBL_MAINT) = ON
     Automatic runstats                  (AUTO_RUNSTATS) = ON
     Automatic statistics profiling    (AUTO_STATS_PROF) = OFF
       Automatic profile updates         (AUTO_PROF_UPD) = OFF
     Automatic reorganization               (AUTO_REORG) = OFF


slnx: db2 get db cfg for sample completed ok


       Database Configuration for Database sample

 Database configuration release level                    = 0x0b00
 Database release level                                  = 0x0b00

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

 Dynamic SQL Query management           (DYN_QUERY_MGMT) = DISABLE

 Discovery support for this database       (DISCOVER_DB) = ENABLE

 Restrict access                                         = NO
 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

 Self tuning memory                    (SELF_TUNING_MEM) = OFF
 Size of database shared memory (4KB)  (DATABASE_MEMORY) = COMPUTED
 Database memory threshold               (DB_MEM_THRESH) = 10
 Max storage for lock list (4KB)              (LOCKLIST) = 100
 Percent. of lock lists per application       (MAXLOCKS) = 10
 Package cache size (4KB)                   (PCKCACHESZ) = (MAXAPPLS*8)
 Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 5000
 Sort list heap (4KB)                         (SORTHEAP) = 256

 Database heap (4KB)                            (DBHEAP) = 1200
 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
 Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 40000
 Percent of mem for appl. group heap   (GROUPHEAP_RATIO) = 70
 Max appl. control heap size (4KB)     (APP_CTL_HEAP_SZ) = 512

 SQL statement heap (4KB)                     (STMTHEAP) = 2048
 Default application heap (4KB)             (APPLHEAPSZ) = 64
 Statistics heap size (4KB)               (STAT_HEAP_SZ) = 4384

 Interval for checking deadlock (ms)         (DLCHKTIME) = 10000
 Lock timeout (sec)                        (LOCKTIMEOUT) = -1

 Changed pages threshold                (CHNGPGS_THRESH) = 60
 Number of asynchronous page cleaners   (NUM_IOCLEANERS) = AUTOMATIC
 Number of I/O servers                   (NUM_IOSERVERS) = AUTOMATIC
 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) = AUTOMATIC
 Max DB files open per application            (MAXFILOP) = 64

 Log file size (4KB)                         (LOGFILSIZ) = 1000
 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/dbtest/dbtest/NODE0001/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 max primary 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) = ON
   Automatic database backup            (AUTO_DB_BACKUP) = OFF
   Automatic table maintenance          (AUTO_TBL_MAINT) = ON
     Automatic runstats                  (AUTO_RUNSTATS) = ON
     Automatic statistics profiling    (AUTO_STATS_PROF) = OFF
       Automatic profile updates         (AUTO_PROF_UPD) = OFF
     Automatic reorganization               (AUTO_REORG) = OFF


slnx: db2 get db cfg for sample completed ok


=======================================================================
=======================================================================
=======================================================================

$ db2set -all
[i] DB2COMM=tcpip
[g] DB2SYSTEM=slnx
[g] DB2INSTDEF=dbtest


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

This shows that all features are enabled during evaluation: http://www.ibm.com/developerworks/downloads/im/udb/?S_TACT=105AGX28&S_CMP=TRIALS


I'm looking through this APAR at the moment.  Currently waiting for my instance to crash so I can compare...

http://www-1.ibm.com/support/docview.wss?rs=203&context=SSEPGG&dc=D420&dc=D421&dc=D422&dc=D42G3&dc=D424&dc=D425&dc=D428&dc=D410&dc=D412&dc=D413&dc=DB550&dc=D100&dc=D430&q1=partition&uid=swg1IY95972&loc=en_US&cs=UTF-8&lang=all

Keith
0
 
LVL 46

Expert Comment

by:Kent Olsen
ID: 20022705
Hi Keith, ghp7000,

I don't think that this is an agent issue.  There are two "automatic" agents with V9 that didn't exist in earlier versions.  These agents don't count toward the user count.


kent
0
 
LVL 46

Expert Comment

by:Kent Olsen
ID: 20022723

Hi Keith,

Good link on the APAR.  It got me to thinking, which can be dangerous.  ;)

Does your database crash if you bring it up gracefully and leave it completely idle (no connections) or does it crash after a connection, query, or other event?


Kent
0
 
LVL 5

Author Comment

by:ocgstyles
ID: 20023841
Hi Kent,

I *think* it only crashes after a connection.  If I remember correctly, I tested just connecting and remaining idle, and connecting and executing SQL, but cases failed.  I'll have to retry to be certain.

I brought the instance up a few minutes ago and I have not tried connecting yet.  I'll see what happens after a half hour.  If it was going to crash, it should by then.

Keith
0
 
LVL 5

Author Comment

by:ocgstyles
ID: 20024086
Still up...

Instance was started @ 2007-10-05-13.19.49.089248.  Its now 13:59.  40 minutes have passed, and no crash.

You on to something Kent?
0
 
LVL 46

Expert Comment

by:Kent Olsen
ID: 20028623

What happens if you now query something that's not partitioned?

select count(*) from sysibm.tables;


Kent
0
 
LVL 5

Accepted Solution

by:
ocgstyles earned 0 total points
ID: 20029001
I tried installing Fix Pack 3 earlier this morning.  I then ran a bunch of queries against the system tables and the SAMPLE tables (similar to how Kdo suggested).  I left two connections to the database and left home for a few hours...

After I arrived home, about 8 hours later, all the connections were still there and I could still execute queries.

Maybe something in Fix Pack 3 fixed it.

Keith
0
 
LVL 46

Expert Comment

by:Kent Olsen
ID: 20029099


   :)
0
 
LVL 1

Expert Comment

by:Vee_Mod
ID: 20199875
Closed, 500 points refunded.
Vee_Mod
Community Support Moderator
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question