Toad World® Forums

Script for Table ist not showing up

I try to display the script for a certain z/OS table in TOAD for DB2 (6.3.0.232 (32 bit)) but it will never been shown.
There ist just a Line: “-- Generating script in background” showing up and a Task ist running in the backgrout that cannot be canceled.
The same happens when I try to extract the DDL.

I tried to do the same in Toad 6.2. There I got a display but with a small error.There is a extra ’ in front of the last X’FF’: PARTITION 22 ENDING AT (X’FF’,X’FF’,‘X’FF’) )

CREATE TABLE “#DB26DA1”.OHPS_ADRESSE (
PARTNER_NR INTEGER NOT NULL,
ADRESS_NR SMALLINT NOT NULL,
ERFASSZEIT_TS TIMESTAMP NOT NULL WITH DEFAULT,
ART_CD SMALLINT NOT NULL WITH DEFAULT,
SPRACH_CD SMALLINT NOT NULL WITH DEFAULT,
ZUSTELL_CD SMALLINT NOT NULL WITH DEFAULT,
ADRESSZUS CHARACTER(35) FOR SBCS DATA NOT NULL WITH DEFAULT,
STRASSE CHARACTER(35) FOR SBCS DATA NOT NULL WITH DEFAULT,
HAUSNUMMER CHARACTER(10) FOR SBCS DATA NOT NULL WITH DEFAULT,
HNRDAR_CD SMALLINT NOT NULL WITH DEFAULT,
POSTFACH CHARACTER(10) FOR SBCS DATA NOT NULL WITH DEFAULT,
PLZ CHARACTER(10) FOR SBCS DATA NOT NULL WITH DEFAULT,
PLZ_ZUS CHARACTER(2) FOR SBCS DATA NOT NULL WITH DEFAULT,
ORT CHARACTER(30) FOR SBCS DATA NOT NULL WITH DEFAULT,
KANTON_CD SMALLINT NOT NULL WITH DEFAULT,
GEMEINDENR CHARACTER(5) FOR SBCS DATA NOT NULL WITH DEFAULT,
PROVINZ CHARACTER(35) FOR SBCS DATA NOT NULL WITH DEFAULT,
LAND_CD SMALLINT NOT NULL WITH DEFAULT,
KOMBZEIL_CD SMALLINT NOT NULL WITH DEFAULT,
ANREDE_CD SMALLINT NOT NULL WITH DEFAULT,
TITELDAR_CD SMALLINT NOT NULL WITH DEFAULT,
VORNDARST CHARACTER(30) FOR SBCS DATA NOT NULL WITH DEFAULT,
NAMEDAR_CD SMALLINT NOT NULL WITH DEFAULT,
NZUSDAR_CD SMALLINT NOT NULL WITH DEFAULT,
NOTIZ CHARACTER(70) FOR SBCS DATA NOT NULL WITH DEFAULT,
GLTAB_DT DATE NOT NULL WITH DEFAULT,
GLTBIS_DT DATE NOT NULL WITH DEFAULT,
ERFASSER CHARACTER(8) FOR SBCS DATA NOT NULL WITH DEFAULT,
SPRACHCODE CHARACTER(1) FOR SBCS DATA NOT NULL WITH DEFAULT,
ORT_ZUSATZ CHARACTER(35) FOR SBCS DATA NOT NULL WITH DEFAULT,
INTKFZ CHARACTER(3) FOR SBCS DATA NOT NULL WITH DEFAULT,
POSTFACH_DEF SMALLINT NOT NULL WITH DEFAULT,
HIST_TS TIMESTAMP WITH DEFAULT
) PARTITION BY RANGE (
PARTNER_NR,
ADRESS_NR,
ERFASSZEIT_TS ) (
PARTITION 1 ENDING AT (10399999),
PARTITION 2 ENDING AT (10799999),
PARTITION 3 ENDING AT (11199999),
PARTITION 4 ENDING AT (11599999),
PARTITION 5 ENDING AT (11999999),
PARTITION 6 ENDING AT (12399999),
PARTITION 7 ENDING AT (12799999),
PARTITION 8 ENDING AT (13199999),
PARTITION 9 ENDING AT (13599999),
PARTITION 10 ENDING AT (13999999),
PARTITION 11 ENDING AT (14399999),
PARTITION 12 ENDING AT (14799999),
PARTITION 13 ENDING AT (14999999),
PARTITION 14 ENDING AT (15199999),
PARTITION 15 ENDING AT (15399999),
PARTITION 16 ENDING AT (15599999),
PARTITION 17 ENDING AT (15799999),
PARTITION 18 ENDING AT (15999999),
PARTITION 19 ENDING AT (16199999),
PARTITION 20 ENDING AT (16399999),
PARTITION 21 ENDING AT (16599999),
PARTITION 22 ENDING AT (X’FF’,X’FF’,‘X’FF’) )
IN DPSH002.SPSH019
AUDIT NONE
DATA CAPTURE NONE
NOT VOLATILE
APPEND NO;

Martin

When I use 6.2 or 6.3 and I create the table with part 22 key as:

PARTITION 22 ENDING AT (MAXVALUE,MAXVALUE,MAXVALUE) )

I see the script with

PARTITION 22 ENDING AT (MAXVALUE,MAXVALUE,MAXVALUE) )

(which is OK and valid)

What values did you specify when you created your part 22?

Hi Jeff

There are two Tables (one for the actual data and one for the historical data). The actual Table shows the correct DDL.

Both tables are pretty old. Originally these were index partitioned tablespaces which have been convertet to table controlled partitioning.

Perhaps they have been converted in different ways, but I don’t remember anymore. This also happed quite some time ago…

I’m not shure if you will be able to reproduce our situation with actual DDL.

All I can show you is what I see in the catalog tables (see attachment).

I also attach the DDL that Toad 6.2 is generating for these two tables.

I hope this information helps you to understand the situation.

If you need more, please feel free to ask.

Thanks and kind regards

Martin

(See attached file: Wrong DDL for TABLE - Catalog Tables.txt)(See attached file: Wrong DDL for TABLE - OBPS_ADRESSE.sql)(See attached file: Wrong DDL for TABLE - OHPS_ADRESSE.sql)

Jeff Podlasek —15.05.2017 23:26:23—RE: Script for Table ist not showing up Reply by Jeff Podlasek Martin When I use 6.2 or 6.3 and I

Jeff Podlasek —15.05.2017 23:26:23—RE: Script for Table ist not showing up Reply by Jeff Podlasek Martin When I use 6.2 or 6.3 and I

Von: Jeff Podlasek bounce-Jeff_Podlasek@toadworld.com

An: toaddb2beta@toadworld.com,

Datum: 15.05.2017 23:26

Betreff: RE: [Toad for IBM DB2 - Beta Discussion Forum] Script for Table ist not showing up


RE: Script for Table ist not showing up

Reply by Jeff Podlasek
Martin

When I use 6.2 or 6.3 and I create the table with part 22 key as:

PARTITION 22 ENDING AT (MAXVALUE,MAXVALUE,MAXVALUE) )

I see the script with

PARTITION 22 ENDING AT (MAXVALUE,MAXVALUE,MAXVALUE) )

(which is OK and valid)

What values did you specify when you created your part 22?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for IBM DB2 - Beta Forum notifications altogether.

Toad for IBM DB2 - Beta Discussion Forum

Flag this post as spam/abuse.

Disclaimer: The contents of this email and any attachment thereto are intended exclusively for the attention of the addressee(s). The email and any such attachment(s) may contain information that is confidential and protected on the strength of professional, official or business secrecy laws and regulations or contractual obligations. Should you have received this email by mistake, you may neither make use of nor divulge the contents of the email or of any attachment thereto. In such a case, please inform the email’s sender and delete the message and all attachments without delay from your systems.

You can find our e-mail disclaimer statement in other languages under http://www.baloise.ch/email_disclaimer

Martin,

Thanks for the detailed information - it seems that when converted from a prior release, IBM does not update the catalog correctly.

At this time we do not plan to attempt to address this as we feel IBM’s conversion is in error as new partitioned tables have the catalog entries that are expected.

Thanks again,

Jeff

Hi Jeff

I kinda understand your argumentation.

On the other hand. the DB2 catalog cannot be really false and there are serveral other points in the catalog where there are entries comming from a “weired” convertion.

which cannot be recreated in a newer version. For examplthey padded DBNAME with blanks when they changed data type to varchar…

So you have to deal with the truth, an the catalog is always the truth…

I can live with the false DDL version TOAD generates in V6.2. But if TOAD 6.3 doesn’t show ANY DDL for such a table, that will be a heavy impact for us.

We have quite a bunch of tables that were converted. And we will not be able to touch such a table with TOAD anymore; this will be a very bad situation…

Thanks and kind regards

Martin

Jeff Podlasek —19.05.2017 17:55:48—RE: Script for Table ist not showing up Reply by Jeff Podlasek Martin, Thanks for the detailed in

Jeff Podlasek —19.05.2017 17:55:48—RE: Script for Table ist not showing up Reply by Jeff Podlasek Martin, Thanks for the detailed in

Von: Jeff Podlasek bounce-Jeff_Podlasek@toadworld.com

An: toaddb2beta@toadworld.com,

Datum: 19.05.2017 17:55

Betreff: RE: [Toad for IBM DB2 - Beta Discussion Forum] Script for Table ist not showing up


RE: Script for Table ist not showing up

Reply by Jeff Podlasek
Martin,

Thanks for the detailed information - it seems that when converted from a prior release, IBM does not update the catalog correctly.

At this time we do not plan to attempt to address this as we feel IBM’s conversion is in error as new partitioned tables have the catalog entries that are expected.

Thanks again,

Jeff

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for IBM DB2 - Beta Forum notifications altogether.

Toad for IBM DB2 - Beta Discussion Forum

Flag this post as spam/abuse.

Disclaimer: The contents of this email and any attachment thereto are intended exclusively for the attention of the addressee(s). The email and any such attachment(s) may contain information that is confidential and protected on the strength of professional, official or business secrecy laws and regulations or contractual obligations. Should you have received this email by mistake, you may neither make use of nor divulge the contents of the email or of any attachment thereto. In such a case, please inform the email’s sender and delete the message and all attachments without delay from your systems.

You can find our e-mail disclaimer statement in other languages under http://www.baloise.ch/email_disclaimer