Best way to free inactive trigger packages?

G B

Best way to free inactive trigger packages?

What is the best method for freeing inactive package copies for trigger packages?  I would like to clean them up without drop-recreate.  Is that possible?

Walter Janißen

AW: Best way to free inactive trigger packages?
(in response to G B)
Hi

Did you try FREE PACKAGE … PLANMGMTSCOPE(INACTIVE)

According tot he SQL Reference Manual this seems to be possible:

Freeing trigger packages
You can free package copies for triggers and SQL routines. However,
PLANMGMTSCOPE(ALL) is not supported for trigger packages and SQL
routines. You must issue a DROP statement for the trigger or SQL routine
to free the active package copies.

At least in V12. In V11 it’s not possible:

Freeing trigger packages: You cannot free a trigger package using the FREE
PACKAGE subcommand.

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Spezialisten
Technische Anwendungsarchitektur
Victoriaplatz 2
40477 Düsseldorf
Tel 0211 477-2928
Fax 0211 477-7146
[login to unmask email]

Vorsitzender des Aufsichtsrats: Dr. Markus Rieß
Geschäftsführung: Tomasz Smaczny (Vorsitzender),
Gary Robert Dashwood, Lothar Engelke, Joachim Fensch,
Bernd Jung, Dr. Sebastian Rapsch, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996
Von: Gary Burton [mailto:[login to unmask email]
Gesendet: Dienstag, 12. September 2017 16:28
An: [login to unmask email]
Betreff: [DB2-L] - Best way to free inactive trigger packages?


What is the best method for freeing inactive package copies for trigger packages? I would like to clean them up without drop-recreate. Is that possible?

-----End Original Message-----

G B

RE: AW: Best way to free inactive trigger packages?
(in response to Walter Janißen)

It is my understanding that you can't execute free package commands against trigger packages.

Walter Janißen

AW: AW: Best way to free inactive trigger packages?
(in response to G B)
Apparently in V12 it seems to work.

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: Gary Burton [mailto:[login to unmask email]
Gesendet: Dienstag, 12. September 2017 16:45
An: [login to unmask email]
Betreff: [DB2-L] - RE: AW: Best way to free inactive trigger packages?


It is my understanding that you can't execute free package commands against trigger packages.

-----End Original Message-----
Attachments

  • image001.png (2.6k)