MVSFORUMS.com

[satyenderd]

Hi all,

I have created a database and tables as well i have loaded the tables perfetly. I took backup also perfectly.
But, when I tried to genrate the DDL using control center for the database i am getting SQL22204N error. But I am able to generate DDL table-wise.

I googled but not able to find any perfect solution.
searched links:
http://www-01.ibm.com/support/docview.wss?uid=swg1LI70801


Could anyone please help me in this regard.

Thanks to all in advance.
_________________
Satya

[kolusu]

satyenderd,

what is the version of your operating system? Is it 64 bit OS(windows/linux)? Also the above link mentions that the problem was first fixed in DB2 V8.2 FP10. What is the version you are trying to run?

Kolusu

[satyenderd]

Hi Kolusu,

Thank you very much for your response.

Herein are the details: Database Manager Version: DB2/NT64 Version 9.5.2

Could you please let me know how to generate the DDL for the database on 64bit instance?

Thanks once again.
_________________
Satya

[satyenderd]

Kolusu one more thing I forgot to mention:

DETAILS:

When I have selected the instance name in the control center, on the right side panel, it appeared as :

SYSTEM: XYZ
NODE NAME: DB2AIX
OS TYPE: Windows64BIT
_________________
Satya

[satyenderd]

I Would like to correct the above information:

When I have selected the system name under All systems folder:
Details:

SYSTEM: XYZ
NODE NAME: DB2AIX
OS TYPE: Windows64BIT

When I have selected the instance name under Instance folder:
Details:

SYSTEM: XYZ
Protocol: TCP/IP

When I hav selected the Database name:
Details:

Alias name: DB2A
SYSTEM: XYZ
Type: Remote

Sorry for that.
_________________
Satya

[satyenderd]

Kolusu,

Do I need to Catalog the Database to the node?

For eg:
CATALOG DB DB2A
AS DB2A
AT NODE DB2AIX

When I gave the command LIST NODE DIRECTORY in the command editor:

the following ouput came:

list node directory

Node Directory

Number of entries in the directory = 2

Node 1 entry:

Node name = NDE6E5D4
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = abc.xyz
Service name = ntv21108

Node 2 entry:

Node name = TCPAD814
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = abc.xyz
Service name = 50000



Why is the node name different from the one which I got, when selected the system under All systems folder in control center.
_________________
Satya

[satyenderd]

Kolusu,

When I checked my system information, it is showing as
System Type X86-based PC

Is this shows that I am on Windows32BIT and accessing Windows64BIT?

System Information:(Its a Virtual Machine)

OS Name Microsoft Windows XP Professional
Version 5.1.2600 Service Pack 3 Build 2600
OS Manufacturer Microsoft Corporation
Activation Status Activation Pending (30 days remaining)
System Name ESD1VMNGTS20
System Manufacturer VMware, Inc.
System Model VMware Virtual Platform
System Type X86-based PC
Processor x86 Family 6 Model 29 Stepping 8 GenuineIntel ~2398 Mhz
BIOS Version/Date Phoenix Technologies LTD 6.00, 7/22/2008
SMBIOS Version 2.4
Windows Directory C:\WINDOWS
System Directory C:\WINDOWS\system32
Boot Device \Device\HarddiskVolume1
Locale United States
Hardware Abstraction Layer Version = "5.1.2600.5512 (xpsp.080413-2111)"
User Name ESD1\smurahari
Time Zone Pacific Daylight Time
Total Physical Memory 4,096.00 MB
Available Physical Memory 2.76 GB
Total Virtual Memory 2.00 GB
Available Virtual Memory 1.96 GB
Page File Space 3.96 GB
Page File C:\pagefile.sys


_________________
Satya

[satyenderd]

Hi all,

I have found one rough solution for generating DDL for the tables, whenever we get the SQL22204N error.

I tried to install few fix packs, but I failed to install, i dont know why.

Solution:

Right click on the table name select generate ddl and then uncheck "table space,database partition groups, and buffer pools" in "statement" tab in "Table list".

You can generate upto 30 tables at a time in this way.

Its a rough answer.
_________________
Satya