[DB2 V8 NFM] Problems with VE V8

Walter Janißen

[DB2 V8 NFM] Problems with VE V8
Hi

First of all a happy new year.

I am facing a problem with Visual Explain. For the following query, I don't get any access plan information:

SELECT 'LVTB0220', HH_LFD_NR, A.VNR, RTE_ZHLG_ART_SL,
SCHWEBE_KZ, SCHWEBE_ZUST
FROM DB2.LVTB0220 A,
(SELECT VNR
FROM DB2.LVTB0291
WHERE VNR BETWEEN '030000000' AND '690000000'
AND TARIF_GENERATION = '3'
AND HH_GUELTIG_BIS_DAT = '31.12.9999'
)
HMALT
WHERE RTE_ZHLG_ART_SL = '2'
AND A.VNR = HMALT.VNR
UNION ALL
SELECT 'LVTB0240', HH_LFD_NR, C.VNR, RTE_ZHLG_ART_SL,
' ', ' '
FROM DB2.LVTB0240 C,
(SELECT VNR
FROM DB2.LVTB0291
WHERE VNR BETWEEN '030000000' AND '690000000'
AND TARIF_GENERATION = '3'
AND HH_GUELTIG_BIS_DAT = '31.12.9999'
) HMALT
WHERE RTE_ZHLG_ART_SL = '2'
AND C.VNR = HMALT.VNR
WITH UR

Explains works fine, but no picture of the access path is shown nor can I generate a report for this query. Is this a known bug?
Without the UNION ALL all works fine.

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Laufzeitarchitektur
Hans-Böckler-Str. 36
D-40477 Düsseldorf
Tel.: +49 211 477-2928
Fax: +49 211 477-2615
mailto:[login to unmask email]
http:// www.itergo.com
Vorsitzender des Aufsichtsrats: Dr. Torsten Oletzky
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Dr. Michael Regauer, Wolfgang Schön.
Sitz: Düsseldorf | Handelsregister: Amtsgericht Düsseldorf, HRB 37996


-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Raf Mathijs
Gesendet: Mittwoch, 2. Januar 2008 15:55
An: [login to unmask email]
Betreff: [DB2-L] db2 9.1 HADR + WAS 6.0.2 + type 4 driver

can anyone help me what steps I should undertake to make the alternate server adress of the hadr couple persistent over jvm's ( when jvm would go down was can reconnect normally to alternate adress when failed over)

because the documentation i find seems unclear, jndi datasources tcr4bind ...

would you advise someone to use this with the type 4 driver or to don't bother with all this and use the type 2 driver instead

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Walter Janißen

[DB2 V8 NFM] Problems with VE V8
(in response to Marc --- Sr. Database Analyst --- CFS Costa)
Hi

First of all a happy new year.

I am facing a problem with Visual Explain. For the following query, I don't get any access plan information:

SELECT 'LVTB0220', HH_LFD_NR, A.VNR, RTE_ZHLG_ART_SL,
SCHWEBE_KZ, SCHWEBE_ZUST
FROM DB2.LVTB0220 A,
(SELECT VNR
FROM DB2.LVTB0291
WHERE VNR BETWEEN '030000000' AND '690000000'
AND TARIF_GENERATION = '3'
AND HH_GUELTIG_BIS_DAT = '31.12.9999'
)
HMALT
WHERE RTE_ZHLG_ART_SL = '2'
AND A.VNR = HMALT.VNR
UNION ALL
SELECT 'LVTB0240', HH_LFD_NR, C.VNR, RTE_ZHLG_ART_SL,
' ', ' '
FROM DB2.LVTB0240 C,
(SELECT VNR
FROM DB2.LVTB0291
WHERE VNR BETWEEN '030000000' AND '690000000'
AND TARIF_GENERATION = '3'
AND HH_GUELTIG_BIS_DAT = '31.12.9999'
) HMALT
WHERE RTE_ZHLG_ART_SL = '2'
AND C.VNR = HMALT.VNR
WITH UR

Explains works fine, but no picture of the access path is shown nor can I generate a report for this query. Is this a known bug?
Without the UNION ALL all works fine.

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Laufzeitarchitektur
Hans-Böckler-Str. 36
D-40477 Düsseldorf
Tel.: +49 211 477-2928
Fax: +49 211 477-2615
mailto:[login to unmask email]
http:// www.itergo.com
Vorsitzender des Aufsichtsrats: Dr. Torsten Oletzky
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Dr. Michael Regauer, Wolfgang Schön.
Sitz: Düsseldorf | Handelsregister: Amtsgericht Düsseldorf, HRB 37996


-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Raf Mathijs
Gesendet: Mittwoch, 2. Januar 2008 15:55
An: [login to unmask email]
Betreff: [DB2-L] db2 9.1 HADR + WAS 6.0.2 + type 4 driver

can anyone help me what steps I should undertake to make the alternate server adress of the hadr couple persistent over jvm's ( when jvm would go down was can reconnect normally to alternate adress when failed over)

because the documentation i find seems unclear, jndi datasources tcr4bind ...

would you advise someone to use this with the type 4 driver or to don't bother with all this and use the type 2 driver instead

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

The information contained in this e-mail may be confidential and is intended solely for the use of the named addressee.
Access, copying or re-use of the e-mail or any information contained therein by any other person is not authorized.
If you are not the intended recipient please notify us immediately by returning the e-mail to the originator.(16b)

Disclaimer Version MB.US.1

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Marc --- Sr. Database Analyst --- CFS Costa

Re: [DB2 V8 NFM] Problems with VE V8
(in response to Walter Janißen)
Walter,

What fix pack of Visual Explain are you using? I had a user report the same problem. The user had an older version, so I had him upgrade to fix pack 12 (not sure if that is the latest one or not) and that resolved the issue of no picture.

Thanks,
Marc

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of [login to unmask email]
Sent: Wednesday, January 02, 2008 8:39 AM
To: [login to unmask email]
Subject: [DB2-L] [DB2 V8 NFM] Problems with VE V8

Hi

First of all a happy new year.

I am facing a problem with Visual Explain. For the following query, I don't get any access plan information:

SELECT 'LVTB0220', HH_LFD_NR, A.VNR, RTE_ZHLG_ART_SL,
SCHWEBE_KZ, SCHWEBE_ZUST
FROM DB2.LVTB0220 A,
(SELECT VNR
FROM DB2.LVTB0291
WHERE VNR BETWEEN '030000000' AND '690000000'
AND TARIF_GENERATION = '3'
AND HH_GUELTIG_BIS_DAT = '31.12.9999'
)
HMALT
WHERE RTE_ZHLG_ART_SL = '2'
AND A.VNR = HMALT.VNR
UNION ALL
SELECT 'LVTB0240', HH_LFD_NR, C.VNR, RTE_ZHLG_ART_SL,
' ', ' '
FROM DB2.LVTB0240 C,
(SELECT VNR
FROM DB2.LVTB0291
WHERE VNR BETWEEN '030000000' AND '690000000'
AND TARIF_GENERATION = '3'
AND HH_GUELTIG_BIS_DAT = '31.12.9999'
) HMALT
WHERE RTE_ZHLG_ART_SL = '2'
AND C.VNR = HMALT.VNR
WITH UR

Explains works fine, but no picture of the access path is shown nor can I generate a report for this query. Is this a known bug?
Without the UNION ALL all works fine.

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Laufzeitarchitektur
Hans-Böckler-Str. 36
D-40477 Düsseldorf
Tel.: +49 211 477-2928
Fax: +49 211 477-2615
mailto:[login to unmask email]
http:// www.itergo.com
Vorsitzender des Aufsichtsrats: Dr. Torsten Oletzky
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Dr. Michael Regauer, Wolfgang Schön.
Sitz: Düsseldorf | Handelsregister: Amtsgericht Düsseldorf, HRB 37996


-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Raf Mathijs
Gesendet: Mittwoch, 2. Januar 2008 15:55
An: [login to unmask email]
Betreff: [DB2-L] db2 9.1 HADR + WAS 6.0.2 + type 4 driver

can anyone help me what steps I should undertake to make the alternate server adress of the hadr couple persistent over jvm's ( when jvm would go down was can reconnect normally to alternate adress when failed over)

because the documentation i find seems unclear, jndi datasources tcr4bind ...

would you advise someone to use this with the type 4 driver or to don't bother with all this and use the type 2 driver instead

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

**********************************************************************
This message contains information that is confidential and proprietary to FedEx Freight or its affiliates. It is intended only for the recipient named and for the express purpose(s) described therein. Any other use is prohibited.
**********************************************************************

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms