473,387 Members | 1,435 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > db2 database > questions > db2 v7.2 trap after fp5

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

db2 V7.2 trap after FP5

Hi All,
I know that db2 V7.2 is no more supported and nor OS/2 is supported
anymore but I wonder if someone here can give me some help on this.

Platform: DB2 V7.2 FixPak 14
OS: OS/2 (actually ECS 1.2 latest fixpak)

I've migrated our production database from DB2 V5.2 to V7.2 GA for OS/2
which is the latest available for this platform. Migration succeded and
database works OK.
But after installing the latest FixPak 14 I am not able any more to
execute some query against our database. In particular there is a query
over a view that gives the following errors in DB2DIAG.LOG (and a trap
file).
Please note that this happens with all fixpak from FixPak 5 to FixPak
14 (while FixPak 4 still works). Moroever I've tried to eliminate some
columns from the select statement inside the view and magically the
query worked again.

----

2006-07-04-09.45.49.610000 Instance:DB2 Node:000
PID:156(DB2SYSC.EXE) TID:11 Appid:*LOCAL.DB2.060704134536
data_management sqldmPrefetchList Probe:462 Database:DBASTORI

LIST PREFETCH got list in reverse order.
72 0...55f4 ffff U...

2006-07-04-09.45.49.620000 Instance:DB2 Node:000
PID:156(DB2SYSC.EXE) TID:11 Appid:*LOCAL.DB2.060704134536
global_services sqlzerdm Probe:40 Database:DBASTORI

55f4 ffff U...
2006-07-04-09.45.49.640000 Instance:DB2 Node:000
PID:156(DB2SYSC.EXE) TID:11 Appid:*LOCAL.DB2.060704134536
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:DBASTORI
DIA3876C A data management services programming error occurred.

2006-07-04-09.45.49.650000 Instance:DB2 Node:000
PID:156(DB2SYSC.EXE) TID:11 Appid:*LOCAL.DB2.060704134536
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:DBASTORI
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFF455".

Data Title:SQLCA PID:156 TID:11 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 2
sqlerrmc: 85
sqlerrp : sqlripfrU¶
sqlerrd : (1) 0xFFFFF455 (2) 0x00000055 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

Dump File:C:\SQLLIB\DB2\15611.000 Data:SQLCA
Dump File:C:\SQLLIB\DB2\15611.000 Data:DB2RA

Data Title:CREATOR PID:156 TID:11 Node:000
4e55 4c4c 4944 2020 NULLID
Data Title:PACKAGE PID:156 TID:11 Node:000
5351 4c43 3239 4436 SQLC29D6

Dump File:C:\SQLLIB\DB2\15611.000 Data:CREATOR
Dump File:C:\SQLLIB\DB2\15611.000 Data:PACKAGE
Dump File:C:\SQLLIB\DB2\15611.000 Data:REQUEST TYPE
Dump File:C:\SQLLIB\DB2\15611.000 Data:Recursive dump_sect
Dump File:C:\SQLLIB\DB2\15611.000 Data:PACKAGE ENTRY
Dump File:C:\SQLLIB\DB2\15611.000 Data:USED_IN_UOW BIT VECTOR
Dump File:C:\SQLLIB\DB2\15611.000 Data:SECTION NUMBER
Dump File:C:\SQLLIB\DB2\15611.000 Data:SECTION DIR ENTRY
Dump File:C:\SQLLIB\DB2\15611.000 Data:cursor name
Dump File:C:\SQLLIB\DB2\15611.000 Data:cache cb

Data Title:section stmt PID:156 TID:11 Node:000
5345 4c45 4354 202a 2046 524f 4d20 4d4f SELECT * FROM MO

5649 4d45 4e54 4920 5748 4552 4520 4e55 VIMENTI WHERE NU

4d45 524f 4f52 4449 4e45 3d31 3430 3030 MEROORDINE=14000
Dump File:C:\SQLLIB\DB2\15611.000 Data:section stmt
Dump File:C:\SQLLIB\DB2\15611.000 Data:sentptr
Dump File:C:\SQLLIB\DB2\15611.000 Data:sentptr->sectlen
Dump File:C:\SQLLIB\DB2\15611.000 Data:sentptr->cache_cb
Dump File:C:\SQLLIB\DB2\15611.000
Data:sentptr->cache_cb->cached_sectptr
Dump File:C:\SQLLIB\DB2\15611.000
Data:sentptr->cache_cb->cached_sectptr->thread_list
Dump File:C:\SQLLIB\DB2\15611.000 Data:calculated section size (1): not
including thread list
Dump File:C:\SQLLIB\DB2\15611.000 Data:calculated section size(2):
including thread structure
Dump File:C:\SQLLIB\DB2\15611.000 Data:thd_table
Dump File:C:\SQLLIB\DB2\15611.000 Data:thd_table->size
Dump File:C:\SQLLIB\DB2\15611.000 Data:calculated section size(3):
including thread list table
Dump File:C:\SQLLIB\DB2\15611.000 Data:the_section
Dump File:C:\SQLLIB\DB2\15611.000 Data:Relocated section
Dump File:C:\SQLLIB\DB2\15611.000 Data:Section relocated; reltables
dumped
Dump File:C:\SQLLIB\DB2\15611.000 Data:section ptr
Dump File:C:\SQLLIB\DB2\15611.000 Data:section size
Dump File:C:\SQLLIB\DB2\15611.000 Data:dynamic ptr
Dump File:C:\SQLLIB\DB2\15611.000 Data:dynamic size
Dump File:C:\SQLLIB\DB2\15611.000 Data:shared dynamic ptr
Dump File:C:\SQLLIB\DB2\15611.000 Data:shared dynamic size
Dump File:C:\SQLLIB\DB2\15611.000 Data:dynamic section header
Dump File:C:\SQLLIB\DB2\15611.000 Data:offset in section
Dump File:C:\SQLLIB\DB2\15611.000 Data:opcode
Dump File:C:\SQLLIB\DB2\15611.000 Data:agg_mode
Dump File:C:\SQLLIB\DB2\15611.000 Data:section1
Dump File:C:\SQLLIB\DB2\15611.000 Data:dynamic buffer

Jul 4 '06 #1
1 1948
Ok,
I've rewritten the view that was causing the trap and now the trap
disappeared regardless the fixpak applied.
>From one side I am happy to have solved the problem but from the other
I would be very gratefull to the gurus of this forum if they could
teach me why a query rewrite has this effect.

The orginal view was:

CREATE VIEW MOVIMENTI
AS SELECT

T1.RIGAREGISTRO,
T1.CAUSALE,
T1.CODICEARTICOLO,
T3.DESCRIZIONE,
T1.QUANTITA,
T1.CODICELOTTO,
T1.DATAMOVIMENTO,
T1.CQGENITORE,
T7.CODICEARTICOLO AS ARTICOLOFIGLIO,
T1.BADGE,
T5.DATAORDINE,
T1.NUMEROORDINE,
T1.NUMERORIGA AS NUMERORIGAORDINE,
T5.RIFERIMENTO,
T5.CODICECLIENTE,
T6.NOMEBREVE,
T5.CODICEDESTINAZIONE,
T8.DATADDT,
T8.NUMERODDT,
T8.NUMERORIGA AS NUMERORIGADDT,
T9.DATAFATTURA,
T9.NUMEROFATTURA,
T9.NUMERORIGA AS NUMERORIGAFATTURA

FROM
REGISTROMAGAZZINO T1 JOIN ARTICOLI T3 ON
T1.CODICEARTICOLO=T3.CODICEARTICOLO
LEFT JOIN DDTCLIENTI T8 ON T1.RIGAREGISTRO = T8.RIGAREGISTRO
LEFT JOIN FATTURECLIENTI T9 ON T1.RIGAREGISTRO = T9.RIGAREGISTRO
LEFT JOIN LOTTI T2 ON T1.CODICELOTTO=T2.CODICELOTTO
LEFT JOIN TESTATAORDCLI T5 ON (T1.NUMEROORDINE=T5.NUMEROORDINE AND
T5.NUMEROORDINE 0)
LEFT JOIN CLIENTIFORNITORI T6 ON (T5.CODICECLIENTE=T6.CODICECLIFO AND
T6.TIPO=1)
LEFT JOIN LOTTI T7 ON T1.CQGENITORE=T7.CODICELOTTO
;

and

the new reworked view is

CREATE VIEW MOVIMENTI
AS SELECT

T1.RIGAREGISTRO,
T1.CAUSALE,
T1.CODICEARTICOLO,
T3.DESCRIZIONE,
T1.QUANTITA,
T1.CODICELOTTO,
T1.DATAMOVIMENTO,
T1.CQGENITORE,
T7.CODICEARTICOLO AS ARTICOLOFIGLIO,
T1.BADGE,
T5.DATAORDINE,
T1.NUMEROORDINE,
T1.NUMERORIGA AS NUMERORIGAORDINE,
T5.RIFERIMENTO,
T5.CODICECLIENTE,
T6.NOMEBREVE AS NOMEBREVE,
T5.CODICEDESTINAZIONE,
T8.DATADDT,
T8.NUMERODDT,
T8.NUMERORIGA AS NUMERORIGADDT,
T9.DATAFATTURA,
T9.NUMEROFATTURA,
T9.NUMERORIGA AS NUMERORIGAFATTURA

FROM
REGISTROMAGAZZINO T1 JOIN ARTICOLI T3 ON
T1.CODICEARTICOLO=T3.CODICEARTICOLO
LEFT JOIN DDTCLIENTI T8 ON T1.RIGAREGISTRO = T8.RIGAREGISTRO
LEFT JOIN FATTURECLIENTI T9 ON T1.RIGAREGISTRO = T9.RIGAREGISTRO
LEFT JOIN LOTTI T2 ON T1.CODICELOTTO=T2.CODICELOTTO
LEFT JOIN LOTTI T7 ON T1.CQGENITORE=T7.CODICELOTTO
LEFT JOIN
(TESTATAORDCLI T5
INNER JOIN CLIENTIFORNITORI T6 ON (T5.NUMEROORDINE 0 AND
T5.CODICECLIENTE=T6.CODICECLIFO AND T6.TIPO=1)
) ON (T1.NUMEROORDINE=T5.NUMEROORDINE)
;
Massimiliano Campagnoli ha scritto:
Hi All,
I know that db2 V7.2 is no more supported and nor OS/2 is supported
anymore but I wonder if someone here can give me some help on this.

Platform: DB2 V7.2 FixPak 14
OS: OS/2 (actually ECS 1.2 latest fixpak)

I've migrated our production database from DB2 V5.2 to V7.2 GA for OS/2
which is the latest available for this platform. Migration succeded and
database works OK.
But after installing the latest FixPak 14 I am not able any more to
execute some query against our database. In particular there is a query
over a view that gives the following errors in DB2DIAG.LOG (and a trap
file).
Please note that this happens with all fixpak from FixPak 5 to FixPak
14 (while FixPak 4 still works). Moroever I've tried to eliminate some
columns from the select statement inside the view and magically the
query worked again.

----

2006-07-04-09.45.49.610000 Instance:DB2 Node:000
PID:156(DB2SYSC.EXE) TID:11 Appid:*LOCAL.DB2.060704134536
data_management sqldmPrefetchList Probe:462 Database:DBASTORI

LIST PREFETCH got list in reverse order.
72 0...55f4 ffff U...

2006-07-04-09.45.49.620000 Instance:DB2 Node:000
PID:156(DB2SYSC.EXE) TID:11 Appid:*LOCAL.DB2.060704134536
global_services sqlzerdm Probe:40 Database:DBASTORI

55f4 ffff U...
2006-07-04-09.45.49.640000 Instance:DB2 Node:000
PID:156(DB2SYSC.EXE) TID:11 Appid:*LOCAL.DB2.060704134536
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:DBASTORI
DIA3876C A data management services programming error occurred.

2006-07-04-09.45.49.650000 Instance:DB2 Node:000
PID:156(DB2SYSC.EXE) TID:11 Appid:*LOCAL.DB2.060704134536
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:DBASTORI
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFF455".

Data Title:SQLCA PID:156 TID:11 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 2
sqlerrmc: 85
sqlerrp : sqlripfrU¶
sqlerrd : (1) 0xFFFFF455 (2) 0x00000055 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

Dump File:C:\SQLLIB\DB2\15611.000 Data:SQLCA
Dump File:C:\SQLLIB\DB2\15611.000 Data:DB2RA

Data Title:CREATOR PID:156 TID:11 Node:000
4e55 4c4c 4944 2020 NULLID
Data Title:PACKAGE PID:156 TID:11 Node:000
5351 4c43 3239 4436 SQLC29D6

Dump File:C:\SQLLIB\DB2\15611.000 Data:CREATOR
Dump File:C:\SQLLIB\DB2\15611.000 Data:PACKAGE
Dump File:C:\SQLLIB\DB2\15611.000 Data:REQUEST TYPE
Dump File:C:\SQLLIB\DB2\15611.000 Data:Recursive dump_sect
Dump File:C:\SQLLIB\DB2\15611.000 Data:PACKAGE ENTRY
Dump File:C:\SQLLIB\DB2\15611.000 Data:USED_IN_UOW BIT VECTOR
Dump File:C:\SQLLIB\DB2\15611.000 Data:SECTION NUMBER
Dump File:C:\SQLLIB\DB2\15611.000 Data:SECTION DIR ENTRY
Dump File:C:\SQLLIB\DB2\15611.000 Data:cursor name
Dump File:C:\SQLLIB\DB2\15611.000 Data:cache cb

Data Title:section stmt PID:156 TID:11 Node:000
5345 4c45 4354 202a 2046 524f 4d20 4d4f SELECT * FROM MO

5649 4d45 4e54 4920 5748 4552 4520 4e55 VIMENTI WHERE NU

4d45 524f 4f52 4449 4e45 3d31 3430 3030 MEROORDINE=14000
Dump File:C:\SQLLIB\DB2\15611.000 Data:section stmt
Dump File:C:\SQLLIB\DB2\15611.000 Data:sentptr
Dump File:C:\SQLLIB\DB2\15611.000 Data:sentptr->sectlen
Dump File:C:\SQLLIB\DB2\15611.000 Data:sentptr->cache_cb
Dump File:C:\SQLLIB\DB2\15611.000
Data:sentptr->cache_cb->cached_sectptr
Dump File:C:\SQLLIB\DB2\15611.000
Data:sentptr->cache_cb->cached_sectptr->thread_list
Dump File:C:\SQLLIB\DB2\15611.000 Data:calculated section size (1): not
including thread list
Dump File:C:\SQLLIB\DB2\15611.000 Data:calculated section size(2):
including thread structure
Dump File:C:\SQLLIB\DB2\15611.000 Data:thd_table
Dump File:C:\SQLLIB\DB2\15611.000 Data:thd_table->size
Dump File:C:\SQLLIB\DB2\15611.000 Data:calculated section size(3):
including thread list table
Dump File:C:\SQLLIB\DB2\15611.000 Data:the_section
Dump File:C:\SQLLIB\DB2\15611.000 Data:Relocated section
Dump File:C:\SQLLIB\DB2\15611.000 Data:Section relocated; reltables
dumped
Dump File:C:\SQLLIB\DB2\15611.000 Data:section ptr
Dump File:C:\SQLLIB\DB2\15611.000 Data:section size
Dump File:C:\SQLLIB\DB2\15611.000 Data:dynamic ptr
Dump File:C:\SQLLIB\DB2\15611.000 Data:dynamic size
Dump File:C:\SQLLIB\DB2\15611.000 Data:shared dynamic ptr
Dump File:C:\SQLLIB\DB2\15611.000 Data:shared dynamic size
Dump File:C:\SQLLIB\DB2\15611.000 Data:dynamic section header
Dump File:C:\SQLLIB\DB2\15611.000 Data:offset in section
Dump File:C:\SQLLIB\DB2\15611.000 Data:opcode
Dump File:C:\SQLLIB\DB2\15611.000 Data:agg_mode
Dump File:C:\SQLLIB\DB2\15611.000 Data:section1
Dump File:C:\SQLLIB\DB2\15611.000 Data:dynamic buffer
Jul 4 '06 #2
New Post

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

Similar topics

10
trap primary key error (ASP, SP and SQL2000)
by: Mike D | last post by:
I have a table in SQL 2000 with a composite Primary Key on coulumns Instrument_ID (int) and WeekOf (smalldatetime.) I am running asp on win 2003. I insert values using a stored procedure from...
ASP / Active Server Pages
2
WSE 8.1.5 LUW Trap file not written as claimed?
by: aj | last post by:
DB2 WSE LUW 8.1 Fixpak 5 Red Hat AS 2.1 Has anyone ever seen a db2diag.log indicate that a trap file was written, but it is *not* written? For the 3rd time in 18 months, I had a production...
DB2 Database
11
trap representation
by: pemo | last post by:
Ambiguous? I have a student who's asked me to explain the following std text (esp. the footnote). 6.2.6.1.5 Certain object representations need not represent a value of the object type. If...
C / C++
2
Trap representation
by: ramu | last post by:
Hi, I read the phrase " trap representation" in the topic "Union arrangement" in this group. Can you please tell me what do you mean by it? regards
C / C++
10
Trap Representations - c99 [again]
by: pemo | last post by:
As far as I understand it, a trap representation means something like - an uninitialised automatic variable might /implicitly/ hold a bit-pattern that, if read, *might* cause a 'trap' (I'm not...
C / C++
2
how to trap/detect when entering textbox via tabkey?
by: Rich | last post by:
Hello, I need to trap/detect when a textbox is entered via the tabkey. If the textbox is not empty when entered via the tabkey then set focus to next textbox. To enter that textbox would then...
Visual Basic .NET
0
sending an SNMP trap in c#. how?
by: Bill Schmidt | last post by:
I am attempting to send an SNMP trap using C#. however I have been unable to find a way to do it. websearching has turned up a small number of 3rd party tools that should be able to do this,...
C# / C Sharp
6
inside scanf
by: temper3243 | last post by:
Hi Can someone explain me what is happening below ? Why is it printing 401380 $ cat scanf.c #include<stdio.h> int main() { int i; scanf(" %d",&i);
C / C++
17
Trap representations for unsigned integers
by: Army1987 | last post by:
If uMyInt_t is an unsigned integral type, is the following a necessary and sufficient condition that uMyInt_t has no trap representation? (uMyInt_t)(-1) >CHAR_BIT*sizeof(uMyInt_t)-1 That is,...
C / C++
0
Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"
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,...
General
0
Batch import of multiple excel files into the database
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
Data Management
0
Merging data from multiple Excel files
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
Data Management
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
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...
Algorithms / Advanced Math
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
1
Is that possible of reading the .csv file in column wise and the column have different lengths ?
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...
C / C++
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
The easy way to turn off automatic updates for Windows 10/11
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
Windows Server

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.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!