home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IC56734 Status: Closed

DBWORKER AND DBSCHEDULER THREADS ON 11.50.FC1 GENERATE AF IN
STMTMON_HOSTVARS() WHILE SQLTRACE LEVEL IS SET TO HIGH

product:
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50
Problem description:
When the 'level' argument of SQLTRACE parameter is set to 
'high' in Informix Dynamic Server (IDS) 11.50.FC1 on HP-UX and 
the instance is started, the dbWorker and dbScheduler threads 
generate assertion failure in function stmtmon_hostvars(): 
SQLTRACE level=high,ntraces=1000,size=2,mode=global 
12:56:41  IBM Informix Dynamic Server Version 11.50.FC1 
Software Serial Number AAA#B000000 
12:56:41  Assert Failed: Exception Caught. Type: MT_EX_OS, 
Context: mem 
12:56:41   Who: Session(19, informix@, 0, c000000008a70868) 
  Thread(50, dbScheduler, c000000008a332c8, 1) 
  File: mtex.c Line: 406 
12:56:41   Action: Please notify IBM Informix Technical 
Support. 
12:56:41  Raw hex dump of stack located in 
/usr2/support/products/IDS1150FC1/tmp/af.41a2649.rawstk 
12:56:41  Stack for thread: 50 dbScheduler 
 base: 0xc00000000a1aa000 
  len:  135168 
   pc: 0x0000000000000000 
  tos: 0xc00000000a1ad180 
state: running 
   vp: 1 
legacy_hp_afstack 
afstack 
afhandler 
affail_interface 
mt_ex_throw_sig 
afsig_handler 
_sigreturn 
stmtmon_hostvars 
stmtmon_insert 
close_cursor 
sql_close 
sq_close 
check_and_close_statement 
mi_close_statement 
ph_get_next_task 
db_sched 
udrlm_clang_execute_internal 
udrlm_clang_execute 
udrlm_exec_routine 
udr_execute 
dbsched_start_udr 
startup 
resume
Problem Summary:
**************************************************************** 
USERS AFFECTED: 
All users on 11.50.xC1 and later on Solaris and Hewlett Packard. 
**************************************************************** 
PROBLEM DESCRIPTION: 
Users may see an assert failure (AF) in function 
stmtmon_hostvars() when the user has set the SQLTRACE 
level=high. 
**************************************************************** 
RECOMMENDATION: 
Upgrade to 11.50.xC2 or above. 
****************************************************************
Local Fix:


Solution


Problem has been fixed in 11.50.xC2.


Workaround


not known / see Local fix


Timestamps


Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

02.06.2008
25.09.2008
25.09.2008


Problem solved at the following versions (IBM BugInfos)


11.50.xC2



Problem solved according to the fixlist(s) of the following version(s)


11.50.xC2

FixList