How to automate SQL packages deletion prior to IPL to apply PTF's ?

[Former Member]

Hi,

When PTF's need to be applied to the system to avoid trouble it is recommended to delete the SQL packages. The only way to do this that I know of is by using the R3MAIN menu to access the option to delete the SQL packages. As we have two instances on our system this is (to much) time consuming.

For this reason I would like to schedule a STOP of both SAP instances. Followed by some method to check if the SAP instance is down. If the SAP instance is down I would like to Delete the SQL packages and when this task completes I would like to send myself an e-mail confirming this deletion.

The pieces of the puzzle I am missing to achieve all this are:

1. How to check if SAP is done ?

2. How to delete the SQL packages for both instances in a program ?

Of course it would be perfect if it is possible to check for any active SAP users from a program also. I think I have the CL programming skills to write such a program and of course I want to share that information once the program has been tested and approved by me

Regards, Rudi van Helvoirt

[Former Member]

Hi Rudi,

I would do it in QSTRUP after IPL, but that's a minor difference.

with an *ALLOBJ user:

CALL R3sid400/R3INLPGM

DLTR3PKG sid

As this sometimes fails, I would code the DLTR3PKG 3-5 times into the CL - the second and more ones are done within a second - so no problem )

You do this for each SID and should be happy - as you do not want this with every IPL I guess, you might want to use a DTAARA in order to control this.

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[Former Member]

Hello Volker,

Thanks for the answer to my second question, but after having looked at your answer I noticed a typo in my first question. The first question should have been: How to check if SAP is down ?

In the past I have noticed that in some cases the first delete of the SQL packages fails, so I think I need to program a loop until the messages pops up that the SQL packages are deleted. All what is left now before I start programming is a way to check if SAP is down.

Regards, Rudi van Helvoirt

[Former Member]

Hi,

as said: That's why I would use it AFTER the IPL ...

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[Former Member]

Hello Volker,

Sorry for being a little bit slow in understanding your point.

As the iNav SAP plug-in is able to detect if an instance is up and running or stopped, there might be an easy way to check this. The fact that I would like to know how this is done is beyond the answer to my question. The solution you provided is an answer to my questions. For that I would like to thank you.

Regards, Rudi van Helvoirt

[Former Member]

Hi,

there is an option to do an RFC logon e.g. ...

but: If you use STOPSAP now and wait 30s - this will tell you: down

... but, you know, that it is still up ...

Otherwise, you should ask the developers of this plugin what they do ...

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de