Question & Answer
Question
How do you find the query and plan ID within a SPU core file's backtrace?
Answer
1. Once in the debugger for a SPU core file, run the backtrace (bt) command:
- powerpc-eabi-gdb spu7.elf core_10.0.9.12_20081008_205537
.
.
.
.
(gdb) bt
#0 0x000d17f0 in ecinfo.29748 ()
at /production/builds/rel-4.0.6-patch/080729-7971rel-4.0.6-patch/main/src/nde/spu/swapmgr.cpp:3894
#1 0x000d9140 in GetFreeZoneMapBlk (this=0x2, recP=0xd7ce2bd0, whichPart=CORE)
at /production/builds/rel-4.0.6-patch/080729-7971rel-4.0.6-patch/main/src/nde/spu/zonemap.cpp:3148
.
.
.
2. To get the query that was running at the time of the core file, enter the following command:
- (gdb) p Nz->planDictionary->m_PlanList->m_queryStr
The following is an example of the output:
- $1 = {
s = 0xd7078640 "delete from w_rtl_sls a where a.dt_id between '11579' and '11608' and a.createxid <> (select b.createxid from tmp_xid b)", prev = 0xd74124ac, next = 0xd74124ac}
3. To get the plan ID for that query, enter the following command:
- (gdb) p Nz->planDictionary->m_PlanList->m_planid
The following is an example of the output:
- $2 = 619904
[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
NZ994540
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21574658