亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Chinaunix

標(biāo)題: ［求助］在DB2 CLI命令下執(zhí)行SNAPSHOT_**時(shí)報(bào)SQLSTATE=58004 [打印本頁]

作者: dongwaguan 時(shí)間: 2010-07-30 15:54
標(biāo)題: ［求助］在DB2 CLI命令下執(zhí)行SNAPSHOT_**時(shí)報(bào)SQLSTATE=58004
各們專家：
我在在DB2 CLI命令下執(zhí)行SNAPSHOT_**時(shí)報(bào)SQLSTATE=58004。請(qǐng)各位專家不吝賜教，萬分感謝！

下面報(bào)錯(cuò)時(shí)的語句與系統(tǒng)提示。

db2 => SELECT deadlocks, lock_escals, locks_waiting,  appls_cur_cons FROM TABLE(SNAPSHOT_DATABASE('XDZX', -1)) AS SNAPSHOT_DATABASE
SQL1042C  An unexpected system error occurred.  SQLSTATE=58004
db2 => select TABLESPACE_NAME,PAGE_SIZE,TOTAL_PAGES,USED_PAGES,FREE_PAGES,case TABLESPACE_TYPE when 1 then 'SMS' else 'DMS' end TYPE,PREFETCH_SIZE,EXTENT_SIZE,TABLESPACE_STATE  FROM TABLE(SNAPSHOT_TBS_CFG('XDZX', -1)) as SNAPSHOT_TBS_CFG
SQL1042C  An unexpected system error occurred.  SQLSTATE=58004

所有涉及到SNAPSHOT_**的快照都無法正常執(zhí)行。
其他快照還包括：

SNAPSHOT_LOCK 數(shù)據(jù)庫級(jí)別上的鎖信息；

SNAPSHOT_DATABASE 數(shù)據(jù)庫信息。

系統(tǒng)環(huán)境是：  hpunix  B11.3  + DB2 V8

DB2 的配置如下：

[ADC-001] 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) = 2.597893e-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) = /opt/java1.4

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

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

作者: huabingl 時(shí)間: 2010-08-01 15:25
沒有打開monitor switch唄

作者: dongwaguan 時(shí)間: 2010-08-01 21:58
謝謝huabingl ，不過我想問一下，如何判斷（或查看）monitor switch 是否已經(jīng)打開？

作者: dongwaguan 時(shí)間: 2010-08-01 22:03
我剛才在網(wǎng)上找到如何查看 “monitor switch 是否已經(jīng)打開”的語句了。

　日常監(jiān)控

　　在系統(tǒng)運(yùn)行過程中，我們可以使用 DB2 提供的快照監(jiān)控器和事件監(jiān)控器來收集 BPEDB 的操作和性能信息。通常，這些信息對(duì)優(yōu)化系統(tǒng)配置參數(shù)和問題診斷（例如某些 BPC API 查詢語句執(zhí)行時(shí)間較長(zhǎng)）非常有用；同時(shí)，這些日常的系統(tǒng)監(jiān)控?cái)?shù)據(jù)還可以作為背景信息，在出現(xiàn)問題的情況下可以與其進(jìn)行對(duì)比來分析問題發(fā)生的原因。

　　通過快照監(jiān)控器，可以檢查 BPEDB 在特定時(shí)間點(diǎn)的狀態(tài)。在使用快照監(jiān)控器之前，先確定需要設(shè)置的監(jiān)控開關(guān)。BPEDB 常用的監(jiān)控開關(guān)包括以下（名稱）：

　　鎖定等待及與時(shí)間相關(guān)的鎖定的信息（LOCK）

　　緩沖池活動(dòng)信息（BUFFERPOOL）

　　SQL 語句信息（STATEMENT）

　　時(shí)間和時(shí)間戳記信息（TIMESTAMP）

　　在缺省情況下，除了時(shí)間和時(shí)間戳記信息的開關(guān)在缺省情況下設(shè)置為“ON”，其余信息類型相對(duì)應(yīng)的開關(guān)全部設(shè)置為“OFF”�？蓤�(zhí)行下面的命令獲取當(dāng)前數(shù)據(jù)庫會(huì)話的監(jiān)控開關(guān)狀態(tài)信息：

　　db2 GET MONITOR SWITCHES

　　打開（關(guān)閉）監(jiān)控開關(guān)：

　　db2 UPDATE MONITOR SWITCHES USING – switch_name ON(OFF)

（完成語句）db2 "update monitor switches using lock ON sort ON bufferpool ON uow ON table ON statement ON"

　　說明：必須具有 SYSADM、SYSCTRL、SYSMAINT 或 SYSMON 權(quán)限才能更新監(jiān)控器開關(guān)或獲取快照信息。

最后還是要非常感謝huabingl 提點(diǎn)啊

歡迎光臨 Chinaunix (http://72891.cn/)