论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2003-08-01 11:52 |只看该作者 |倒序浏览

昨天服务器换了一个cpu后，今天我就发觉我得数据库连不上去了。错误情况如下：
db2 =>; connect to sample_db  user db2inst1
Enter current password for db2inst1:
SQL1084C  Shared memory segments cannot be allocated. SQLSTATE=57019

我用db2 get db cfg for sample_db后，修改了DBHEAP的参数，从2000改为4000，结果还是出现上面的错误。

是不是还要改些关于内存的参数？请大家帮忙。谢谢！

附：其余参数

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

Database territory                                     = CN
Database code page                                     = 1383
Database code set                                     = IBM-eucCN
Database country code                                  = 86

Dynamic SQL Query management          (DYN_QUERY_MGMT) = DISABLE

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

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

Backup pending                                        = NO

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

Multi-page file allocation enabled                   = NO

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

Data Links Token Expiry Interval (sec)    (DL_EXPINT) = 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) = 4000
Catalog cache size (4KB)             (CATALOGCACHE_SZ) = 64
Log buffer size (4KB)                      (LOGBUFSZ) = 32
Utilities heap size (4KB)             (UTIL_HEAP_SZ) = 70000
Buffer pool size (pages)                   (BUFFPAGE) = 5000
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 appl. control heap size (4KB)    (APP_CTL_HEAP_SZ) = 512

Sort list heap (4KB)                      (SORTHEAP) = 4000
SQL statement heap (4KB)                   (STMTHEAP) = 2048
Default application heap (4KB)          (APPLHEAPSZ) = 64
Package cache size (4KB)                (PCKCACHESZ) = (MAXAPPLS*

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) = 2
Number of I/O servers                (NUM_IOSERVERS) = 16
Index sort flag                            (INDEXSORT) = YES
Sequential detect flag                   (SEQDETECT) = YES
Default prefetch size (pages)       (DFT_PREFETCH_SZ) = 32

Track modified pages                      (TRACKMOD) = OFF

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

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

Log file size (4KB)                      (LOGFILSIZ) = 4000
Number of primary log files             (LOGPRIMARY) = 30
Number of secondary log files             (LOGSECOND) = 98
Changed path to log files                (NEWLOGPATH) =
Path to log files                                     = /crmfs/db2/db2inst1/NODE0000/SQL00001/SQLOGDIR/
First active log file                                  =

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

Auto restart enabled                   (AUTORESTART) = ON
Index re-creation time                      (INDEXREC) = SYSTEM (RESTART)
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) =