Db2 - L

Latest Discussion Posts

  • 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 ...