Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]DB2 Adopter Configuration?
Go
New
Search
Notify
Tools
Reply
  
[CLOSED]DB2 Adopter Configuration?
 Login/Join
 
Platinum Member
posted
Hi,

We have a DB2 adopter (DB2/DB2 warehouse 11 cli) and with following setting:

Bulkload: OFF-Default << only option

CONV_INT_PREC: 11 << as default number
CONV_FLOAT_PREC: 20 << as default
CONV_DEC_PREC: 'EMPTY'
CONV_DEV_SCALE: 'EMPTY'
CONV_LONGCHAR: ALPHA-Default
CONV_LONGCHAR_LEN: 32767 << as default

PASSRECS: ON-Default
LOG_SWITCHED: STOP-Default

ALIAS_CASE: Not enforced
TABLE_OPTIONS: 'EMPTY'

JOINTYPE: 'EMPTY'

FETCHSIZE: 100 << as default
INSERSIZE: 1 << as default
FASTLOAD: ON- Default

AUTODISCONNECT: ON FIN - Default
LOGINTIMEOUT: 'EMPTY'
COMMANDTIMEOUT: 'EMPTY'
ISOLATION: UR

OPTIMIZATION: Optimize
AGGREGATE_AWARENESS: Installation Default

and I notice there is several/majority of my DEFAULT and WC_DEFAULT agent 'crushed' and When I check the log(edaprint), it show as follows:

 

07/28/2020 09:58:40.532 - Dump processing: total=2359 msec, minidump=453 msec, ibisnap2=1890 msec.
07/28/2020 09:58:40.626 I request by t3rp7676 to notify agent is ready (tscomid=527)
07/28/2020 09:58:53.454 I accepting  cmrpip001432 tcp=192.168.225.60:60505
07/28/2020 09:58:53.454 I request by cmrpip001432 from NGXXJ770 for explicit connect to agent (DEFAULT), session=8b312042b6700cc
07/28/2020 09:58:53.454 I connecting cmrpip001432 tscomid=525,sesid=2901,fctkt=5f16b6da:1-8fb,fcdir=ip001432010
07/28/2020 09:58:53.470 I processing cmrpip001432 sesid=2901,u=OPSYS\gsseda,r=SRV
07/28/2020 09:58:53.751 I  (FOC1717) INVALID VALUE UR FOR SET OPTION ISOLATION FOR DB2     
07/28/2020 09:58:53.751 -  (FOC1717) INVALID VALUE UR FOR SET OPTION ISOLATION FOR DB2     
07/28/2020 09:58:55.251 I disconnect cmrpip001432 tscomid=525,sesid=2901,fctkt=5f16b6da:1-8fb,fcdir=ip001432010
07/28/2020 09:58:55.251 I request by t3rp4684 to notify disconnect of sesid=2901
07/28/2020 09:58:55.251 I statistics cmrpip001432 sesid=2901,cpu=1.469s,dbms=0.000s,srv=1.781s
07/28/2020 09:58:58.414 I accepting  cmrpip001433 tcp=192.168.225.60:60506
07/28/2020 09:58:58.414 I request by cmrpip001433 from NGXXJ770 for explicit connect to agent (DEFAULT), session=8b312042b6700cc
07/28/2020 09:58:58.415 I connecting cmrpip001433 tscomid=525,sesid=2902,fctkt=5f16b6da:1-8fc,fcdir=ip001433010
07/28/2020 09:58:58.424 I processing cmrpip001433 sesid=2902,u=OPSYS\gsseda,r=SRV
07/28/2020 09:58:58.673 I  (FOC1717) INVALID VALUE UR FOR SET OPTION ISOLATION FOR DB2     
07/28/2020 09:58:58.673 -  (FOC1717) INVALID VALUE UR FOR SET OPTION ISOLATION FOR DB2     
07/28/2020 09:58:59.074 I disconnect cmrpip001433 tscomid=525,sesid=2902,fctkt=5f16b6da:1-8fc,fcdir=ip001433010
07/28/2020 09:58:59.075 I request by t3rp4684 to notify disconnect of sesid=2902
07/28/2020 09:58:59.075 I statistics cmrpip001433 sesid=2902,cpu=0.375s,dbms=0.003s,srv=0.655s
07/28/2020 09:58:59.125 I accepting  cmrpip001434 tcp=192.168.225.60:60507
07/28/2020 09:58:59.126 I request by cmrpip001434 from NGXXJ770 for explicit connect to agent (DEFAULT), session=8b312042b6700cc
07/28/2020 09:58:59.126 I connecting cmrpip001434 tscomid=525,sesid=2903,fctkt=5f16b6da:1-8fd,fcdir=ip001434010
07/28/2020 09:58:59.133 I processing cmrpip001434 sesid=2903,u=OPSYS\gsseda,r=SRV
07/28/2020 09:58:59.320 I  (FOC1717) INVALID VALUE UR FOR SET OPTION ISOLATION FOR DB2     
07/28/2020 09:58:59.320 -  (FOC1717) INVALID VALUE UR FOR SET OPTION ISOLATION FOR DB2     
07/28/2020 09:59:04.063 W request by edapmon to notify agent has crashed (tscomid=525)
07/28/2020 09:59:04.063 E (EDA60001) Agent (tscomid=525) crashed
07/28/2020 09:59:04.063 - Agent Statistics
07/28/2020 09:59:04.063 -   Tscomid: 525
07/28/2020 09:59:04.063 -   Service: DEFAULT
07/28/2020 09:59:04.063 -   State: in use
07/28/2020 09:59:04.063 -   User: OPSYS\gsseda
07/28/2020 09:59:04.063 -   Group: 
07/28/2020 09:59:04.063 -   Client Session: 8b312042b6700cc
07/28/2020 09:59:04.063 -   Client Address: 192.168.225.60:60507
07/28/2020 09:59:04.063 -   Code Page: 65001
07/28/2020 09:59:04.063 -   DeferID: ---
07/28/2020 09:59:04.063 -   Scheduler Job ID: ---
07/28/2020 09:59:04.063 -   Command:                 
07/28/2020 09:59:04.063 -   Procedure: _ADHOCRQ
07/28/2020 09:59:04.063 -   Top Level Procedure: _ADHOCRQ
07/28/2020 09:59:04.063 -   Master File: wf$hold                        
07/28/2020 09:59:04.063 -   Focus I/O: 0
07/28/2020 09:59:04.063 -   DBMS I/O: 29
07/28/2020 09:59:04.063 -   Response Time: ---
07/28/2020 09:59:04.063 -   DBMS Time: 0:00:00.005
07/28/2020 09:59:04.063 -   Server Time: ---
07/28/2020 09:59:04.063 -   Query Time: Jul 28 09:59:01.001
07/28/2020 09:59:04.063 -   Executed Class: ---
07/28/2020 09:59:04.063 -   Error Number: 0
07/28/2020 09:59:04.063 -   Foccache Ticket: 5f16b6da:1-8fd
07/28/2020 09:59:04.063 -   Number of Transactions: 0
07/28/2020 09:59:04.063 -   Source DBMS Adapter: ---
07/28/2020 09:59:04.063 -   Source Table Name: ---
07/28/2020 09:59:04.063 -   Status: ---
07/28/2020 09:59:04.063 -   Processed Transactions: 0
07/28/2020 09:59:04.063 -   Polling Interval: 0
07/28/2020 09:59:04.063 -   Timeout Interval: 0
07/28/2020 09:59:04.063 -   Transactions Processing Limit: 0
07/28/2020 09:59:04.063 -   Source File Type: ---
07/28/2020 09:59:04.063 -   Source Directory(File): ---
07/28/2020 09:59:04.063 -   File Extension: ---
07/28/2020 09:59:04.063 -   Status: ---
07/28/2020 09:59:04.063 -   Processed Files: 0
07/28/2020 09:59:04.063 -   Processed Bytes: 0
07/28/2020 09:59:04.063 -   Files in wait queue: 0
07/28/2020 09:59:04.063 -   Processing time: 0
07/28/2020 09:59:04.063 -   Wait for work time: 0
07/28/2020 09:59:04.063 -   Average files per second: 0
07/28/2020 09:59:04.063 -   Average bytes per second: 0
07/28/2020 09:59:04.063 -   Average file wait time: 0
07/28/2020 09:59:04.063 -   Polling Interval: 0
07/28/2020 09:59:04.063 -   Timeout Interval: 0
07/28/2020 09:59:04.063 -   Files Processing Limit: 0
07/28/2020 09:59:04.063 -   CPU Time: ---
07/28/2020 09:59:04.063 -   Memory Usage (KB): ---
07/28/2020 09:59:04.063 -   Disk Usage (KB): 0
07/28/2020 09:59:04.063 -   Process ID: 4684
07/28/2020 09:59:04.063 - Process statistics not available - process is gone
07/28/2020 09:59:04.063 - checking dir D:\wf\ibi\srv82\wfs\edatemp\ts000525 after exec of D:\wf\ibi\srv82\home\bin\tscom3.exe
07/28/2020 09:59:04.063 -  Directory of D:\wf\ibi\srv82\wfs\edatemp\ts000525\*.log
07/28/2020 09:59:04.063 - 07/28/20 09:59                 11212 ibisnap2.log
07/28/2020 09:59:04.063 - 07/28/20 09:58                     0 stderr.log
07/28/2020 09:59:04.063 - 07/28/20 09:58                     0 stdout.log
07/28/2020 09:59:04.063 -                3 File(s)
07/28/2020 09:59:04.063 - *** ibisnap.log from D:\wf\ibi\srv82\wfs\edatemp\ts000525, exec=D:\wf\ibi\srv82\home\bin\tscom3.exe
07/28/2020 09:59:04.063 - Copyright (c) 1996-2015 Information Builders, Inc.
07/28/2020 09:59:04.063 - MiniDump was saved to D:\wf\ibi\srv82\wfs\edatemp\ts000525\ibisnap2.dmp
07/28/2020 09:59:04.063 - Analyzing stack for process id#4684, thread id#6376
07/28/2020 09:59:04.063 - Added 'C:\Windows\SYSTEM32\' to dll pathes.
07/28/2020 09:59:04.063 - Added 'D:\wf\ibi\srv82\home\bin\' to dll pathes.
07/28/2020 09:59:04.063 - Added 'C:\Windows\AppPatch\AppPatch64\' to dll pathes.
07/28/2020 09:59:04.063 - Added 'C:\Windows\System32\' to dll pathes.
07/28/2020 09:59:04.063 - Added 'C:\Windows\system32\' to dll pathes.
07/28/2020 09:59:04.063 - 
07/28/2020 09:59:04.063 - Stack information (short):
07/28/2020 09:59:04.063 - Machine type: x64.
07/28/2020 09:59:04.063 -  LineFromAddrError#487 RtlFreeHeap+0x242
07/28/2020 09:59:04.063 -  LoadModuleError#487  LineFromAddrError#487 NotifyShims+0x24151
07/28/2020 09:59:04.063 -  LoadModuleError#487  LineFromAddrError#487 free+0x28
07/28/2020 09:59:04.063 -  LoadModuleError#487  \\win2012\m727710d\source\iohapp.c(858) : (00007FFBF8AE7B17+0xf) iohappCln+0x358
07/28/2020 09:59:04.063 -  LoadModuleError#487  \\win2012\m727710d\source\iohapp.c(911) : (00007FFBF8AE8094+0x0) iohappDsc+0x36
07/28/2020 09:59:04.063 -  LoadModuleError#487  \\win2012\m727710d\source\iohcb.c(571) : (00007FFBF8B00756+0x0) iohcbdsc+0x614
07/28/2020 09:59:04.063 -  LoadModuleError#487  \\win2012\m727710d\source\ioh.c(347) : (00007FFBF8AE19F0+0x0) iohdsc+0x112
07/28/2020 09:59:04.063 -  LoadModuleError#487  \\win2012\m727710d\source\rthcrt.c(2624) : (00007FFBF81A0C89+0x0) rtdinit+0x1625
07/28/2020 09:59:04.063 -  LoadModuleError#487  \\win2012\m727710d\source\rthcrt.c(1627) : (00007FFBF81A11BC+0x8) rtdsc+0x916
07/28/2020 09:59:04.063 -  LoadModuleError#487  \\win2012\m727710d\source\nwsrv.c(345) : (00007FFBF921EE42+0x0) nwsrvdsc+0x306
07/28/2020 09:59:04.063 -  LoadModuleError#487  \\win2012\m727710d\source\nwh.c(1175) : (00007FFBF9214518+0x0) nwexeloop+0x792
07/28/2020 09:59:04.063 -  LoadModuleError#487  \\win2012\m727710d\source\nwh.c(1314) : (00007FFBF92167F7+0x0) nwloop+0x695
07/28/2020 09:59:04.063 -  \\win2012\m727710d\source\tscom3.c(592) : (00007FF61F26240B+0x0) tscom3a+0x2139
07/28/2020 09:59:04.063 -  LoadModuleError#487  f:\dd\vctools\crt_bld\self_64_amd64\crt\src\crtexe.c(536) : (00007FF61F292B3E+0x19) __tmainCRTStartup+0x271
07/28/2020 09:59:04.063 -  LoadModuleError#487  LineFromAddrError#487 BaseThreadInitThunk+0x20
07/28/2020 09:59:04.063 -  LoadModuleError#487  LineFromAddrError#487 RtlUserThreadStart+0x33

 


I notice there is something may be wrong at '(FOC1717) INVALID VALUE UR FOR SET OPTION ISOLATION FOR DB2'

So I guess maybe something wrong with DB2's adopter configuration? and maybe something at ISOLATION: UR ?

and I read about this following link:

https://webfocusinfocenter.inf...ver/source/db296.htm

can someone brief explain those Isolation Level? (I'm not familiar with DB2)
Very appreciate.

This message has been edited. Last edited by: nox,


WebFOCUS v8.2.06 , Windows
 
Posts: 98 | Registered: August 29, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Here are the valid isolation codes for DB2
RR is the repeatable read.
CS is the default for DB2 driver, it stands for Cursor Stability and
if you use that the DB only will give you free pages, not the ones
that are beeing updated or in use
RU is uncomitted read, also known as "dirty read".
With this option you will not see all of the updates
RS is Read Stability

I think you may have wanted to use RU


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1993 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]DB2 Adopter Configuration?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.