Monday, March 20, 2017

DMP error CTL GDO error: package name 0 is missing



Product Categories   - PDE Parallel Database Extensions


Problem

/var/log/messages ‐
Jan 16 14:24:28 test1‐2 dmp[5699]: DEGRADED: TdatTools: 29003 #PDE DMP Utility ‐‐ CTL GDO
error: package name 0 is missing

Because of DMP error, csppeek failed
Warning cdbopen: object <dump_name> is not a dump

Also, loading or attaching to the raw crashdump gave an error
dump belongs to a different PDE version

Environment/Conditions/Configuration

Cause

/etc/opt/teradata/tdconfig/control.gdo does not have correct packages names.



Solution :

Correct control.gdo using ctl. No need to restart the database, or, no need to bring the database down to make these changes.

After correcting the control.gdo, next time the crashdump is generated, won't have "CTL GDO error: package name 0 is missing" the issue.

Example test1‐
2:/# ctl
> print labels
Running PDE=14.10.04.09
Running DBS=14.10.04.11
Running RSG=
Running TGTW=14.10.04.08
Running TCHN=14.10.04.04
Running TDGSS=14.10.04.01
Running PDEGPL=14.10.04.09
DBS Package Name=PDE
PDE Package Name=
PDEGPL Package Name=TDBMS
RSG Package Name=PDEGPL
TCHN Package Name=TGTW
TDGSS Package Name=TCHN
TGTW Package Name=RSG
>>
DBS Package Name=TDBMS
> PDE Package Name=PDE
> PDEGPL Package Name=PDEGPL
> RSG Package Name=RSG
> TCHN Package Name=TCHN
> TDGSS Package Name=TDGSS
> TGTW Package Name=TGTW
> write
CTL: Control GDO successfully written.
> q

test1‐2:/#


Additional Information :

/var/opt/teradata/tdtemp/gdom/PDE_control.gdo.1 can be viewed to see when the values of control.gdo got changed.

No comments:

Post a Comment