00C90205

[login to unmask email]

00C90205
Hi all.

We have DB2 Version 7 (just migrated from V5) running in Z/OS 1.4.
We had a problem of index inconsistencies :

DSNI013I -DB2Q DSNIONX2 POTENTIALLY INCONSISTENT 424
DATA
REASON 00C90205
ERQUAL 5005
TYPE 00000302
NAME DCTRG040.SCTRGY43.X'000011A2'
CONNECTION-ID=DB2CALL
CORRELATION-ID=KKU039
LUW-ID=*

I would like to know if you have any notice about this. I really don't
know why this did happen and can't reproduce the situation. IBM has
referred some PTFs, but we have them applied.

Thank you

Fátima

***************************************************************************
AVISO DE CONFIDENCIALIDADE: Esta mensagem, assim como os ficheiros
eventualmente anexos, é confidencial e reservada apenas ao conhecimento
da(s) pessoa(s) nela indicada(s) como destinatária(s). Se não é o seu
destinatário, solicitamos que não faça qualquer uso do respectivo conteúdo
e proceda à sua destruição, notificando o remetente.
LIMITAÇÃO DE RESPONSABILIDADE: A segurança da transmissão de informação
por via electrónica não pode ser garantida pelo remetente, o qual, em
consequência, não se responsabiliza por qualquer facto susceptível de
afectar a sua integridade.

CONFIDENTIALITY NOTICE: This message, as well as existing attached files,
is confidential and intended exclusively for the individual(s) named as
addressees. If you are not the intended recipient, you are kindly requested
not to make any use whatsoever of its contents and to proceed to the
destruction of the message, thereby notifying the sender.
DISCLAIMER: The sender of this message can not ensure the security of its
electronical transmission and consequently does not accept liability for
any fact which may interfere with the integrity of its content.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Jeremiah Eden

Re: 00C90205
(in response to Fatima.Osorio@BPORTUGAL.PT)
What DB2 maintenance level are you at?

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Wednesday, December 03, 2003 10:16 AM
To: [login to unmask email]
Subject: 00C90205


Hi all.

We have DB2 Version 7 (just migrated from V5) running in Z/OS 1.4.
We had a problem of index inconsistencies :

DSNI013I -DB2Q DSNIONX2 POTENTIALLY INCONSISTENT 424
DATA
REASON 00C90205
ERQUAL 5005
TYPE 00000302
NAME DCTRG040.SCTRGY43.X'000011A2'
CONNECTION-ID=DB2CALL
CORRELATION-ID=KKU039
LUW-ID=*

I would like to know if you have any notice about this. I really don't
know why this did happen and can't reproduce the situation. IBM has
referred some PTFs, but we have them applied.

Thank you

Fátima

***************************************************************************
AVISO DE CONFIDENCIALIDADE: Esta mensagem, assim como os ficheiros
eventualmente anexos, é confidencial e reservada apenas ao conhecimento
da(s) pessoa(s) nela indicada(s) como destinatária(s). Se não é o seu
destinatário, solicitamos que não faça qualquer uso do respectivo conteúdo
e proceda à sua destruição, notificando o remetente.
LIMITAÇÃO DE RESPONSABILIDADE: A segurança da transmissão de informação
por via electrónica não pode ser garantida pelo remetente, o qual, em
consequência, não se responsabiliza por qualquer facto susceptível de
afectar a sua integridade.

CONFIDENTIALITY NOTICE: This message, as well as existing attached files,
is confidential and intended exclusively for the individual(s) named as
addressees. If you are not the intended recipient, you are kindly requested
not to make any use whatsoever of its contents and to proceed to the
destruction of the message, thereby notifying the sender.
DISCLAIMER: The sender of this message can not ensure the security of its
electronical transmission and consequently does not accept liability for
any fact which may interfere with the integrity of its content.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Max Scarpa

Re: 00C90205
(in response to Jeremiah Eden)
Did you reorged the tablespace to which the index(es) belong ?

Did you try to rebuild the index ? I met this error in V5 (years ago) and
it was related to a bug in utility (Reorg) when dealing
with NPIs in partitioned TSs.

Just a trivial hint.

Regards

Max Scarpa

DB2 sysprog
Santa Claus data center - Toys & Dolls department
North Pole

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

[login to unmask email]

Re: 00C90205
(in response to Max Scarpa)
The maintenance level is 15 August 2003. I did not mention that we are in
data sharing.

***************************************************************************
AVISO DE CONFIDENCIALIDADE: Esta mensagem, assim como os ficheiros
eventualmente anexos, é confidencial e reservada apenas ao conhecimento
da(s) pessoa(s) nela indicada(s) como destinatária(s). Se não é o seu
destinatário, solicitamos que não faça qualquer uso do respectivo conteúdo
e proceda à sua destruição, notificando o remetente.
LIMITAÇÃO DE RESPONSABILIDADE: A segurança da transmissão de informação
por via electrónica não pode ser garantida pelo remetente, o qual, em
consequência, não se responsabiliza por qualquer facto susceptível de
afectar a sua integridade.

CONFIDENTIALITY NOTICE: This message, as well as existing attached files,
is confidential and intended exclusively for the individual(s) named as
addressees. If you are not the intended recipient, you are kindly requested
not to make any use whatsoever of its contents and to proceed to the
destruction of the message, thereby notifying the sender.
DISCLAIMER: The sender of this message can not ensure the security of its
electronical transmission and consequently does not accept liability for
any fact which may interfere with the integrity of its content.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Jeremiah Eden

Re: 00C90205
(in response to Fatima.Osorio@BPORTUGAL.PT)
This is probably what IBM suggested, but do you have on UQ77930 on, its
on RSU0309 PUT0308. I wasn't sure from you comment, whether you meant
RSU, PUT, the date of apply, or when the tape was cut.

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Thursday, December 04, 2003 8:35 AM
To: [login to unmask email]
Subject: Re: 00C90205


The maintenance level is 15 August 2003. I did not mention that we are
in
data sharing.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

[login to unmask email]

Re: 00C90205
(in response to Jeremiah Eden)
Yes, we have that PTF on.

***************************************************************************
AVISO DE CONFIDENCIALIDADE: Esta mensagem, assim como os ficheiros
eventualmente anexos, é confidencial e reservada apenas ao conhecimento
da(s) pessoa(s) nela indicada(s) como destinatária(s). Se não é o seu
destinatário, solicitamos que não faça qualquer uso do respectivo conteúdo
e proceda à sua destruição, notificando o remetente.
LIMITAÇÃO DE RESPONSABILIDADE: A segurança da transmissão de informação
por via electrónica não pode ser garantida pelo remetente, o qual, em
consequência, não se responsabiliza por qualquer facto susceptível de
afectar a sua integridade.

CONFIDENTIALITY NOTICE: This message, as well as existing attached files,
is confidential and intended exclusively for the individual(s) named as
addressees. If you are not the intended recipient, you are kindly requested
not to make any use whatsoever of its contents and to proceed to the
destruction of the message, thereby notifying the sender.
DISCLAIMER: The sender of this message can not ensure the security of its
electronical transmission and consequently does not accept liability for
any fact which may interfere with the integrity of its content.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm