masaly的博客_db2

RS隔离级别导致的锁超时

客户某个数据库突然锁超时增多.通过分析db2locktimeout文件, 发现90%的locktimeout的原因都是因为Read Stability隔离级别导致的。主要涉及的表：P_CUSTOM_ARCH_TABLE,P_CUSTOM_TABLE_ARCH_EXT,P_BUSI_QUERY,P_ALCMNG_PRO。下面是对db2locktimeout.0.282904.2015-05-13-1

隔离

locktimeout

锁超时

原创 2015-05-14 16:33:28 1104 阅读

db2top help

The db2top tool is a monitoring tool that comes packaged with every copy of DB2 for Linux and Unix as of version 9.1 FP6, version 9.5 FP2, and version 9.7 (Linux Power PC as of version 9.7 FP3). If yo

db2top

原创 2015-05-14 16:26:11 1059 阅读

Table has cardinality of 0 after RUNSTATS is performed

After performing RUNSTATS on a non-empty table, why does its cardinality still equal to 0? A 'select count ...' query on the table returns a non-zero value, while a 'select card from syscat.tables

table

runstats

原创 2015-05-12 17:29:16 512 阅读

pureScale环境, 版本兼容很重要.

AIX 7.1 TL3 SP4, AIX 6.1 TL9 SP4 + pureScale V10.5: (2015-01-30)These service packs install RSCT 3.2.0.0. Previous SPs would use the level of RSCT shipped with pureScale, 3.1.5.5 with 10.5 FP4 and 3.1

环境

pureScale

版本兼容

原创 2015-05-11 14:56:45 544 阅读

db2ilist returns blank

The db2ilist command calls either db2iset or db2set depending on the permissions defined for db2iset.db2iset is meant to be executed by root only, while db2set is meant to be executed by a non-root us

root

db2ilist

原创 2015-05-06 12:56:42 1015 阅读

IC90024,为什么没有选择NLJOIN?

IC90024: OPTIMIZER MIGHT FAVOUR HSJOIN OVER AN ORDERED NLJOIN The optimizer might favour a hash join (HSJOIN) over a nested loop join (NLJOIN) alternative under the

IC90024

原创 2015-04-27 23:05:49 745 阅读

WSE convert to ESE, or ESE to WSE.

Example: Update db2inst1 from V9.1 FP4 WSE to V9.1 FP5 ESE.- Stop the db2 instance- As root install V9.1 FP5 ESE to location of your choosing- Still as root cd to install dir then cd to the "instance"

convert instance

原创 2015-04-27 12:08:48 974 阅读

DB2V9.7, Toad报SQL0401N的错误.

错误信息:The data types of the operands for the operation "=" are not compatible or comparable. 原因:db2set设置了DB2_COMPATIBILITY_VECTOR=ORA, DB2_DEFERRED_PREPARE_SEMANTICS=YES.解决方法:1) Keep DB2_C

错误

toad

SQL0401

原创 2015-04-27 10:05:25 1476 阅读

db2ckpwd, db2wdog为什么需要root用户运行.

db2ckpwd:db2ckpwd is the password checking daemon that deals with userauthentication. This process is used to confirm that the id exists andhas a right to be on the box. If the process if not a root p

root

db2ckpwd

db2wdog

原创 2015-04-27 09:59:00 2152 阅读

如何检查备份文件的DB2版本信息

db2ckbkp -h SAMPLE2.0.krodger.NODE0000.CATN0000.19990818122909.001 &

DB2

备份文件

db2ckbkp

原创 2015-04-27 09:50:50 931 阅读

db2dart,/DDEL导出某个schema下的表数据.

db2dart sample /ddelTable object data formatting start.Please enter Table ID or name, tablespace ID, first page, num of pages:SYSTABLES,0,0,999999The output data file is TS0T5.DEL.DBNAME=sampleSCHEMA=

schema

db2dart

DDEL

原创 2015-04-27 09:24:33 2482 阅读

Crash Recovery & SOFTMAX

Redo starting point is minimum of (MinBuffLSN, LowTranLSN)1) MinBuffLSN represents oldest change to page in the buffer pool that hasn't been written to disk2) LowTranLSN represents oldest active uncom

Crash

Recovery

SOFTMAX

原创 2015-04-25 12:00:32 937 阅读

常见的SQL0805N解决方法

Knowledge Collection: SQL0805Nhttp://www-01.ibm.com/support/docview.wss?uid=swg21358478SQL0805N - package NULLID.SYSSH203 cannot be foundhttp://www-01.ibm.com/support/docview.wss?uid=swg21115245

解决方法

SQL0805N

原创 2015-04-24 21:32:05 2029 阅读

坑爹的APAR IT08059.

最近, 为了解决客户某个重要的数据库Crash的问题, 从v97fp9升级到了v97fp10.过了几天, 活动日志满了.早上被客户call起, 急忙赶到现场. 发现是某个应用长时间hold住了最早的事务日志, force不了, 应该是hang住了.收了数据. 10分钟就找到了RCA. 中了APAR IT08059.IT08059:Interrupting a lock escalation may

数据库

APAR

原创 2015-04-24 20:24:11 1331 阅读 1点赞

表空间数据结构研究_01

Space Map Pages (SMPs) hold track of which extents are used and which are free.Extent Map Pages (EMPs) store the mapping of extents held by that object.SMP Extent 0 is always the second extent in the

数据

结构

表空间

原创 2015-04-24 19:21:09 855 阅读

aslheapsz & rqrioblk 相关APAR

aslheapsz - Application support layer heap size.The application support layer heap represents a communication buffer between the local application and its associated agent. This buffer is alloca

apar

aslheapsz

rqrioblk

原创 2015-04-24 14:17:50 694 阅读

PureScale不支持的特性, 表与表空间设计的考虑.

TABLESPACE:Only automatic storage table spaces can be created in a DB2 pureScale environment.In a DB2 pureScale environment, you should use an extent size of at least 32 pages. This minimum extent siz

表

表空间

purescale

原创 2015-04-24 13:11:44 836 阅读

v97fp5后, load问题诊断方法增强.

DB2 9.7 FP5及以后, 新增-load选项, 通过loadid可以获得所有相关的EDU和stack数据.$ db2 list utilities show detailID &n

load

问题诊断

v97fp5

原创 2015-04-24 10:48:28 556 阅读

Recreate an instance

Under some circumstance it may be neccessary to recreate an instance with out dropping the databases. Some OS related error is preventing instance start or a connections to a database. Usually this is

recreate instance

转载精选 2015-04-23 15:59:54 599 阅读

How do DB2 utilities affect transaction logging?

* REORGSpecification of the ONLINE or INPLACE parameters requires more transaction log space than that of OFFLINE, though OFFLINE needs to take a ‘shadow’ copy of the object for the duration of operat

utilities logging

转载精选 2015-04-23 15:44:54 496 阅读

Resolve contention on "workspace_lru_latch"

Problem:In high-workload OLTP systems, contention on "SQLO_LT_sqlra_workspace_mhashcb__workspace_lru_latch" ("workspace_lru_latch" for short) could happen and slow down applications. Symptom:When the

workspace_lru_latch

转载精选 2015-04-23 15:37:22 534 阅读

DB2_COMPATIBILITY_VECTOR=ORA, DATE type

When using Oracle compatibility features on DB2 9.7 (by setting DB2_COMPATIBILITY_VECTOR registry variable to ORA), DATE type columns are created and behave as TIMESTAMP. The following example shows t

DB2_COMPATIBILITY_VE

转载精选 2015-04-23 13:31:26 1172 阅读

删除LOB数据后, LOB空间不能重用的问题.

As records are deleted, the LOB data segments are marked as psuedo-deleted and they can only be reused when the 'readLSN' of the table progresses past the LSN of when the deletes were performed(you ca

空间

lob

重用

原创 2015-04-23 11:25:51 848 阅读

DB2 on P7 system, System CPU may spike.

If there are many CPUs(over 64 CPUs or even to 200 CPUs) on AIX platform, there might be a performance problem(very high CPU) caused by bad performance of thread_unlock during very high db2 latch cont

system

cpu

spike

原创 2015-04-22 15:26:21 1198 阅读

V95和V97的char方法, 数值显示格式不一致.

DB2V9.5:db2 connect to sample Database Connection Information Database server = DB2/AIX64 9.5.7 SQL authorization ID = W95Q7

char

数值

显示格式

原创 2015-04-22 14:55:01 1089 阅读

V9.1升级到V9.5(或以上), 操作lob数据报错

错误信息:com.ibm.db2.jcc.am.SqlException:Invalid operation: Lob is closed.ERRORCODE=-4470, SQLSTATE=null error access lob;解决:1) 设置DB2_RESTRICT_DDFdb2set DB2_RESTRICT_DDF=TRUEdb2stopdb2start2) Disable prog

升级

lob is close

V9.1

原创 2015-04-22 13:55:18 1176 阅读

DB2 V10.5 FP4上严重的APAR IT04326

IT04326: PACKAGE CACHE MEMORY USE CAN EXCEED CONFIGURED SIZE RESULTING IN MEMORY EXHAUSTION ON DB2 Cancun Release 10.5.0.4.Error description This package cache memory problem is spec

DB2

APAR

原创 2015-04-22 10:56:02 840 阅读

银监会通报的DB2 9.7.10的问题

数据库DB2 9.7.10 具有以下BUG：“执行create db、list db directory、backup命令时，会引起数据库缓慢。IT05909: The commands accessing db directory like create db, list db directory may hangError description If th

银监会

APAR

原创 2015-04-22 10:41:29 646 阅读

Slow connection when connecting from a DB2 Windows client

When connecting from a DB2 Windows client with an ID which does not exist in the Windows client or the Windows client’s domain, the connection may take a long time.By default, a DB2 Windows client wou

slow connection

转载精选 2015-04-22 10:34:25 424 阅读

DB2高效分页算法

例:select * from(select a.*,row_number() over(order by a.tableid) as rn from t1 a where exists (select 1 from t2 b where b.tabschema=a.tabschema and b.tabname=a.tabname)) where rn>10 fetch fir

db2

算法

高效分页

原创 2015-04-21 12:29:21 2103 阅读

官方博客	全部文章	热门标签	班级博客
了解我们	网站地图	意见反馈

鸿蒙开发者社区	51CTO学堂
51CTO	软考资讯

51CTO博客

DBA日记

RS隔离级别导致的锁超时

db2top help

Table has cardinality of 0 after RUNSTATS is performed

pureScale环境, 版本兼容很重要.

db2ilist returns blank

IC90024,为什么没有选择NLJOIN?

WSE convert to ESE, or ESE to WSE.

DB2V9.7, Toad报SQL0401N的错误.

db2ckpwd, db2wdog为什么需要root用户运行.

如何检查备份文件的DB2版本信息

db2dart,/DDEL导出某个schema下的表数据.

Crash Recovery & SOFTMAX

常见的SQL0805N解决方法

坑爹的APAR IT08059.

表空间数据结构研究_01

aslheapsz & rqrioblk 相关APAR

PureScale不支持的特性, 表与表空间设计的考虑.

v97fp5后, load问题诊断方法增强.

Recreate an instance

How do DB2 utilities affect transaction logging?

Resolve contention on "workspace_lru_latch"

DB2_COMPATIBILITY_VECTOR=ORA, DATE type

删除LOB数据后, LOB空间不能重用的问题.

DB2 on P7 system, System CPU may spike.

V95和V97的char方法, 数值显示格式不一致.

V9.1升级到V9.5(或以上), 操作lob数据报错

DB2 V10.5 FP4上严重的APAR IT04326

银监会通报的DB2 9.7.10的问题

Slow connection when connecting from a DB2 Windows client

DB2高效分页算法