DB2 - L

 View Only
  • 1.  when adding DB2 add-on products ......

    Posted Dec 04, 2021 06:12 PM

    Such as query monitor, SQL perf analyzer, object comparison, table editor, high performance unload

     

    Do shops add them to the existing DB2 CSI or create a new CSI ?

     

    thanks

     

    Chris Hoelscher

    Lead Sys DBA

    Kyndryl on assignment to Humana Inc.

    T 502.476.2538  or 502.407.7266

     

    The information transmitted is intended only for the person or entity to which it is addressed
    and may contain CONFIDENTIAL material. If you receive this material/information in error,
    please contact the sender and delete or destroy the material/information.

    Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
    do not discriminate on the basis of race, color, national origin, ancestry, age, disability, sex,
    marital status, gender, sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
    exclude people or treat them differently because of race, color, national origin, ancestry, age,
    disability, sex, marital status, gender, sexual orientation, gender identity, or religion.

    English: ATTENTION: If you do not speak English, language assistance services, free
    of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

    Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
    gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

    繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
    服務。請致電 1‐877‐320‐1235 (TTY: 711)。

    Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
    pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

    Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
    pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

    한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
    이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.


  • 2.  RE: when adding DB2 add-on products ......

    Posted Dec 06, 2021 06:56 AM
    Create a new CSI.

    ------------------------------
    JackBrosiusUSS
    ------------------------------



  • 3.  RE: when adding DB2 add-on products ......

    Posted Dec 06, 2021 08:45 PM

    If it's an IBM product and the SREL is "P115", you can probably get away with placing it in the same GLOBAL zone.

    Otherwise, if the SREL isn't P115 or it's another vendor's product, I wouldn't risk it. It would probably be fine, but there is a very remote possibility that certain elements could be incompatible.

    In general, at my current shop, every "product" that ships separately has a separate SMP/E environment, complete with its own GLOBAL CSI.

    This ALSO allows you to take disk-level dumps of the entire SMP/E environment, and restore it from disk independently of Db2 if something in SMP/E gets "hosed".

    If you want to keep everything together, consider a common high-level qualifier(s) to group the datasets together.



    ------------------------------
    MarkWieczorkowski...
    ------------------------------



  • 4.  RE: when adding DB2 add-on products ......

    Posted Dec 08, 2021 09:35 AM
    In my previous shop, we used one SMPE environment for DB2, and one for the IBM tools.
    We installed seven tools together as one event, and we created a combined script for all of them.

    Consider using one SMPE for each install.  If you want to install HPUnload separately from the other tools, then use a separate SMPE for it.

    If you want to install Admin, table editor, and object compare together as one event, then put them in the same SMPE.

    Also, some products have a natural affinity; ie Admin and object compare install best together as  one event.

    I would not combine the tools into the same SMPE as DB2, though.  I my mind, they are separate entities, and should be managed separately.

    I hope this is helpful to you.

    ------------------------------
    RichardArnoldExperian
    ------------------------------