• SQL to Populate Weekly and Monthly PADB Tables

    score0
    Active
    0 votes
    We are experiencing a lot of CPU use when populating our weekly and monthly PADB tables using the DMDBMERG utility. Is there SQL that could be used to populate those tables from the daily tables, to eliminate the need...
    Lana Chrisman
    last modified by Lana Chrisman
  • Another BMC Db2 Coffee Talk in the books

    BMC hosted another coffee talk September 30, this one focusing on Next Generation Technology Reorg for Db2, AKA, BMC AMI Reorg for Db2. Thanks to all those that participated.   A copy of the presentation can be ...
    Michael Cotignola
    last modified by Michael Cotignola
  • NGT_Reorg_Update.pdf

    Copy of Presentation for BMC Db2 Coffee Talk of September 30 - NGT Reorg Update
    Michael Cotignola
    last modified by Michael Cotignola
  • BMC Db2 Coffee Talk

    Join us on September 30th for the next BMC Db2 Coffee talk where we will review some of the recent enhancements to Next Generation Technology Reorg for Db2 that have been introduced in the maintenance stream. Register...
  • Announcing BMC AMI Data for Db2

    You would think, since we have celebrated more than 55 years of the mainframe and more than 35 years of Db2, things would have gotten stale, outdated and to be blunt, technologically antiquated.  But think again!...
    Ryan Smith
    last modified by Ryan Smith
  • SNAPSHOT UPGRADE FEATURE for IMS XBM OSAM error after IBM maintenance

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified. PRODUCT: SNAPSHOT UPGRADE FEATURE for IMS COMPONENT: SNAPSHOT UP...
    Knowledge Admin
    last modified by Knowledge Admin
  • SQL to Populate Weekly and Monthly PADB Tables

    We are experiencing a lot of CPU use when populating our weekly and monthly PADB tables using the DMDBMERG utility. Is there SQL that could be used to populate those tables from the daily tables, to eliminate the need...
    Lana Chrisman
    last modified by Lana Chrisman
  • How do I find the RSL schedule?

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified. PRODUCT: Next Generation Technology Copy for DB2 for z/OS QUEST...
    Knowledge Admin
    last modified by Knowledge Admin
  • Apptune - How many times an object is used/selected from IDAA

    score5
    Active
    1 vote
    Online and Batch report to count by day the number of times an object is used by IDAA.  This will help identify the activity level of the object for obsoletion or value.
    Daron Heinen
    last modified by Daron Heinen
  • Apptune - How many times an object is used/selected from DB2 z/OS

    score5
    Active
    1 vote
    Online and Batch report to count by day the number of times an object is used by Db2 z/OS.  This will help identify the activity level of the object for obsoletion or value.
    Daron Heinen
    last modified by Daron Heinen
  • RECOVER with ANALYZE ONLY fails with BMC40126E TABLESPACE db.ts, PART n IS IN A STATUS WHICH WILL NOT ALLOW RECOVERY

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified. PRODUCT: Next Generation Technology Recover for DB2 for z/OS PR...
    Knowledge Admin
    last modified by Knowledge Admin
  • Can switches be added to "Change Manager Compare" to suppress differences in TS: Dssize and TS: Maxparts

    score30
    Active
    6 votes
    While generating the CDL, CM gives lot of messages like “ALTER DSSIZE”, “ALTER MAXPARTITIONS” etc. which we are not able to suppress from Scope Rules. Is there a way to do that, or can support ...
    Andy Laredo
    last modified by Andy Laredo
  • How can I optimize the drain processing for NGT Reorg, Load and Unload

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified. PRODUCT: Next Generation Technology Reorg for DB2 for z/OS COMPON...
    Knowledge Admin
    last modified by Knowledge Admin
  • Change Manager 12.1 - Change Manager to use the original/active ZPARM per member without ZPARM= parameter in the Option module

    score15
    Active
    3 votes
    We're using ONE default option Module for Change Manager ACMDOPD1 for different resp. all our DSGs. However, there is a parameter ZPARM= pointing per default to IBM-Default ZPARM DSNZPARM causing problems in Change M...
    Thomas Singer
    last modified by Thomas Singer
  • ACP1210: COPY EXPORT command cannot use a defined LOGMARK representing a RBA/LRSN

    score0
    Active
    0 votes
    This idea is published on behalf of customer HUK-COBURG: They would like to refer to a created logmark when using the COPY EXPORT command.   Currently, NGT Copy only allows to use the RBA that is associated wit...
    Christopher Duellmann
    last modified by Christopher Duellmann
  • How to Notify the DBA if any table in the WORKID has IIDR implications

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified. PRODUCT: CHANGE MANAGER for DB2 COMPONENT: Change Manager for DB...
    Knowledge Admin
    last modified by Knowledge Admin
  • NGT Copy V12.1  - ACPMAIN looping or gets S0C4 after applying BQU2574

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified. PRODUCT: Next Generation Technology Copy for DB2 for z/OS COMPONE...
    Knowledge Admin
    last modified by Knowledge Admin
  • Can the grant Table Privileges in Catalog Mgr be ordered by the most likely used first?

    score20
    Active
    4 votes
    Currently, the GRANT Table Privileges option screen gives the list of privileges in what appears to be a random order.   I would like to suggest the table privileges be in the ordered by the ones you use mos...
    Nick De Falco
    last modified by Nick De Falco
  • Why is the Apptune current interval missing after DB2 subsystem termination?

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified. PRODUCT: APPTUNE for DB2 COMPONENT: APPTUNE for DB2 APPLIES TO...
    Knowledge Admin
    last modified by Knowledge Admin
  • BMC73158E* XBMP IMS component hook XBMIOSCC is completely disabled

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified. PRODUCT: SNAPSHOT UPGRADE FEATURE for IMS COMPONENT: SNAPSHOT UP...
    Knowledge Admin
    last modified by Knowledge Admin