473,383 Members | 1,929 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

crash when trying to get snapshot size

Hi all
I have a multi-threaded application running on AIX 5.3 and DB2 8.2 that
takes snapshots from different threads. Each thread that takes snapshot
allocates an application context (using sqleBeginCtx), and frees it
when the thread goes down (using sqleEndCtx).
The application runs well for a while and after a couple of hours it
crashes when it tries to get the snapshot size. After the application
crashes at the first time, it keeps crashing until I restart the
database instance.

I attached at the end a code snippet and the core dump; I'll
appreciate any help with solving this issue.
TIA
YaronG

May 7 '06 #1
2 1429
the code snippet :
RefPtr<SqlmaWrapper> sqlma = new SqlmaWrapper();
sqlma->setSnapshotType(snapshotType);
sqlma->setSnapshotParam(snapshotParam);
memset(&getSnapshotSizeParam,0,sizeof(getSnapshotS izeParam));
getSnapshotSizeParam.piSqlmaData = sqlma->getSqlma();
getSnapshotSizeParam.iVersion = SQLM_CURRENT_VERSION;
getSnapshotSizeParam.iNodeNumber = SQLM_ALL_NODES;
getSnapshotSizeParam.iSnapshotClass = SQLM_CLASS_DEFAULT;
getSnapshotSizeParam.poBufferSize = &buffer_sz;
db2GetSnapshotSize(db2Version820, &getSnapshotSizeParam, &sqlca);

May 7 '06 #2
the core dump:
sqlowque(??, ??, ??) at 0xdba71b3c
sqlccipcconnr__FP13sqlcc_connectP15sqlcc_comhandle P10sqlcc_cond(??, ??,
??) at 0xdbab938c
sqlccconnr__FP13sqlcc_connectP15sqlcc_comhandleP10 sqlcc_cond(??, ??,
??) at 0xdbab3ec4
sqljrInternalConnect__FP11UCconHandleP13sqlcc_conn ectP10sqlcc_condPb(??,
??, ??, ??) at 0xdbb9e9f4
sqljrConnectCCLayer__FP11UCconHandle(??) at 0xdbb9e8fc
sqljrPreConnect__FP7UCintfcPP13sqljrDrdaArCb(??, ??) at 0xdbba06d8
sqljrDrdaArAuthenticate__FP7UCintfclPUl(??, ??, ??) at 0xdb9c5470
sqlexAppAuthenticate__FP7UCintfc__fdpr_1(??) at 0xdb9bfc48
sqljrDrdaArAttach__FP7UCintfc(??) at 0xdbaca860
sqleUCdrdaARinit__FP11UCconHandle(??) at 0xdb9fc2e4
sqleUCappAttach(??, ??, ??, ??, ??) at 0xdbaf2bb8
sqleatin__FPcN41sP5sqlca(??, ??, ??, ??, ??, ??, ??) at 0xdb9edaac
sqleimat__FPcT1iP5sqlca(??, ??, ??, ??) at 0xdb9ee084
sqleriar__FP10sqle_db2ra(??) at 0xdb9ef560
sqlm_send_est_buf_size_db2ra__FUlPUlP5sqlmasT1P5sq lca(0x7, 0x0,
0x20386190, 0xfffefffe, 0x0, 0x2) at 0xdbcec458
db2GetSnapshotSize(??, ??, ??) at 0xdbcebfe4

May 7 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Tejas | last post by:
Hi, I have gone through the snapshot API. I need to use it for finding location of database files, tablespace containers etc on a remote machine. These parameters are present in the response....
3
by: fayez | last post by:
Hi. I have a sql Stored Procedure running on aix5.1, db2 udb 8.1.2 it has a temp table, but when it's done running it does not free heap memory, here is a snapshot of db2diag.log which becomes...
110
by: alf | last post by:
Hi, is it possible that due to OS crash or mysql itself crash or some e.g. SCSI failure to lose all the data stored in the table (let's say million of 1KB rows). In other words what is the worst...
10
by: sara | last post by:
Hi - I have a report that is 14 columnar sub-reports (Line up: Position- holders in each of our 14 locations - Manager, Assistant Manager, Receiving, Office, etc). I output directly to PDF...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.