请教关于SESSION长时间运行不停止问题定位与解决

中级会员 注册时间: 2008-10-16 22:57:30 文章: 34 离线

常遇到一些SESSION长时间运行不停止，但在其他现场运行正常
检查服务器资源未见异常，硬盘空间够用，内存也应该够。

请问一般都能是什么原因造成的呢？以及如何查看一些系统信息，定位问题原因等

请大虾帮忙看看，谢谢

赋SESSION LOG结尾处信息1：
2008-09-29 11:49:15 : INFO : (332068 | TRANSF_1_42_1) : : node01_wk05s : CMN_1690 : Created new data file [/dc2/PowerCenter8.1.1/server/infa_shared/Cache/PMJNR5281_27.dat] and index file [/dc2/PowerCenter8.1.1/server/infa_shared/Cache/PMJNR5281_27.idx] for Joiner [纬度框架].
2008-09-29 11:49:15 : INFO : (332068 | TRANSF_1_42_1) : : node01_wk05s : DBG_21214 : DBG_21214 Finished joiner cache on master relation : (Mon Sep 29 11:49:15 2008)
2008-09-29 11:49:15 : INFO : (332068 | TRANSF_1_42_1) : : node01_wk05s : TE_7032 : The B-Tree being managed in files
/dc2/PowerCenter8.1.1/server/infa_shared/Cache/PMAGG5281_33.dat for Data and

/dc2/PowerCenter8.1.1/server/infa_shared/Cache/PMAGG5281_33.idx for Index has:
Index Size: 1
Row Size: 52
Order: 100
Minimum Order: 50
Height: 1
Entries: 1
IndexPageSize: 1296
IndexPages: 1540
DataPageSize: 528
DataPages: 7560

2008-09-29 11:49:15 : INFO : (332068 | TRANSF_1_13_1) : : node01_wk05s : DBG_21603 : DBG_21603 Open master relation cache for detail joiner : (Mon Sep 29 11:49:15 2008)
2008-09-29 11:49:15 : INFO : (332068 | TRANSF_1_42_1) : : node01_wk05s : DBG_21216 : Finished transformations for Source Qualifier [AGGTRANS5]. Total errors [0]
走到这就停止不动了。

SESSION LOG 2:
2008-10-18 12:55:47 : INFO : (176426 | LKPDP_5:READER_1_1) : : node01_wk05s : BLKR_16003 : Initialization completed successfully.
2008-10-18 12:55:47 : INFO : (176426 | LKPDP_5:READER_1_1) : : node01_wk05s : BLKR_16007 : Reader run started.
2008-10-18 12:55:47 : INFO : (176426 | LKPDP_5:READER_1_1) : : node01_wk05s : RR_4049 : RR_4049 SQL Query issued to database : (Sat Oct 18 12:55:47 2008)
2008-10-18 12:55:47 : INFO : (176426 | LKPDP_5:READER_1_1) : : node01_wk05s : RR_4050 : RR_4050 First row returned from database to reader : (Sat Oct 18 12:55:47 2008)
2008-10-18 12:55:47 : INFO : (176426 | LKPDP_5:READER_1_1) : : node01_wk05s : BLKR_16019 : Read [412] rows, read [0] error rows for source table [LKP_TRADE_TYPE_3{{DSQ}}] instance name [LKP_TRADE_TYPE_3{{SRC}}]
2008-10-18 12:55:47 : INFO : (176426 | LKPDP_5:TRANSF_1_1) : : node01_wk05s : DBG_21079 : DBG_21079 Creating Lookup Cache : (Sat Oct 18 12:55:47 2008)
2008-10-18 12:55:47 : INFO : (176426 | LKPDP_5:TRANSF_1_1) : : node01_wk05s : TT_11195 : WARNING! Found unsorted input when building Lookup cache of [LKP_TRADE_TYPE_3] (Current number of entries in the index cache = 256). Continue building the cache by insertion. This will cause it to take longer and the index cache may require more space. Possibly causes of this are: improper lookup sql override or inconsistent setting of sort order between the database server and PowerCenter.
2008-10-18 12:55:47 : INFO : (176426 | LKPDP_5:TRANSF_1_1) : : node01_wk05s : DBG_21682 : Lookup table row count : 412
2008-10-18 12:55:47 : INFO : (176426 | LKPDP_5:TRANSF_1_1) : : node01_wk05s : DBG_21297 : Lookup cache row count : 412

2008-10-18 12:55:47 : INFO : (176426 | LKPDP_5:TRANSF_1_1) : : node01_wk05s : DBG_21294 : DBG_21294 Lookup cache creation completed : (Sat Oct 18 12:55:47 2008)
2008-10-18 12:55:47 : INFO : (176426 | LKPDP_5:TRANSF_1_1) : : node01_wk05s : CMN_1671 : Created new cache files PMLKUP5295_37A64.[dat/idx] in directory /dc2/PowerCenter8.1.1/server/infa_shared/Cache for Lookup [LKP_TRADE_TYPE_3].
2008-10-18 12:55:47 : INFO : (176426 | LKPDP_5:TRANSF_1_1) : : node01_wk05s : DBG_21641 : LKP_TRADE_TYPE_3: Index cache size = [22370400], Data cache size = [44744704]
2008-10-18 12:55:47 : INFO : (176426 | LKPDP_5:TRANSF_1_1) : : node01_wk05s : DBG_21216 : Finished transformations for Source Qualifier [LKP_TRADE_TYPE_3{{DSQ}}]. Total errors [0]
2008-10-18 12:55:47 : INFO : (176426 | LKPDP_5:READER_1_1) : : node01_wk05s : BLKR_16008 : Reader run completed.
2008-10-18 12:55:47 : INFO : (176426 | TRANSF_1_1_1) : : node01_wk05s : DBG_21077 : DBG_21077 Create joiner cache on master relation : (Sat Oct 18 12:55:47 2008)
2008-10-18 12:55:47 : INFO : (176426 | TRANSF_1_1_1) : : node01_wk05s : TE_7212 : Increasing [Index Cache] size for transformation [JNRTRANS1] from [22369621] to [22380000].
2008-10-18 12:55:47 : INFO : (176426 | TRANSF_1_1_1) : : node01_wk05s : TE_7212 : Increasing [Data Cache] size for transformation [JNRTRANS1] from [44739242] to [44739744].
2008-10-18 12:55:47 : INFO : (176426 | TRANSF_1_1_1) : : node01_wk05s : CMN_1690 : Created new data file [/dc2/PowerCenter8.1.1/server/infa_shared/Cache/PMJNR5295_20.dat] and index file [/dc2/PowerCenter8.1.1/server/infa_shared/Cache/PMJNR5295_20.idx] for Joiner [JNRTRANS1].
这个也是，走到这就不动了

这篇文章被编辑了 2 次. 最近一次更新是在 2008-10-21 23:36:08

问过INFA培训人员
答复不明确只是说WIN系统下可能出现的小BUG
又说小机之类的不会出现

不过楼主常遇到就不知道了
我只是很少遇到概率大概不到1%

中级会员 注册时间: 2008-10-16 22:57:30 文章: 34 离线

zdcku wrote:问过INFA培训人员
答复不明确只是说WIN系统下可能出现的小BUG
又说小机之类的不会出现

不过楼主常遇到就不知道了
我只是很少遇到概率大概不到1%

1%的概率也不小了，几百个MAPPING每个月抽取的话不都能遇到，呵呵

在UNIX下还没遇到过