Db2 - L

I didn't – I did the following Assembled/linked the zparm to reflect the new applcompat which we were comfortable doing immediately in PROD Dynamically reloaded the zparm module Assembled/linked dsnhdecp to reflect new SQLLEVEL – again ...

Is it important to either start in Maint mode or prevent connections when activating a Function Level? thanks Bill ------------------------------ williamgiannelliMe ------------------------------

We have DESCSTAT set to "NO" for application requirements. Which can cause issues if we forget to switch to "YES" for maintenance. I found now that we have DESCSTAT = "NO" for DSNTEP2 DSNTEP4 and DSNTIAUL. Should these be DESCSTAT = "YES"? thanks Bill ...

When I activate a Function Level I do dataset backups, Image Copies and check the Catalog and indexes, before and after. Is there really a need to do that? The catalog is already changed prior to activization and the software is not really changing. thanks ...

You might need to become familiar with setDB2ClientApplicationInformation and RLFEUAN . Problem is that RLF deals with SQL statements, not threads or applications. For those you need a higher level monitor E.g. Omegamon, TMON, Sysview, Mainview, etc ...