• Baseline APPTUNE sql performance tables

    In the manual it says: BASELINE_WKLD_STATISTICS   Statement statistics aggregated by nonstatement collection key (plan, program, user, and so on) representing acceptable performance   It still looks li...
    carol goldberg
    last modified by carol goldberg
  • how do I request the smpe vsam definitions and data for DB2CM V12?

    how do I request the smpe vsam definitions and data for DB2CM V12?
    Ben Strydom
    last modified by Ben Strydom
  • Do NGT REORG and LOAD support  PCTFREE FOR UPDATE -1

    Hi community members. We use NGT for Db2 V12.01.  Some of our tables are defined with parameter PCTFREE FOR UPDATE -1.  Do NGT REORG and LOAD utilities use RTS to automatically calculate the percentage of f...
    EVGENY ZIABKO
    last modified by EVGENY ZIABKO
  • Using LogMaster for zOS to distributed updating

    All, We are currently using LogMaster v11.2 to scan the log of the Prod DB(zOS DB2 11) using a batch job, generate the cntl and data files, and apply the changes to a non-Prod DB(zOS DB2 11) using a batch job. ...
    David Joyce
    last modified by David Joyce
  • Upgrade to BMC v12 question

    All, We are upgrading to BMC v12.  NGT is new with v12, I keep running into issues with job $771PREG in the NGTLOAD, NGTUNLD, and NGTCOPY steps in both DB2 11 and DB2 12.  All other $7* jobs complete succe...
    David Joyce
    last modified by David Joyce
  • NGLARCH

    Hello,   how can i customize the NGLARCH proc in v11.2  ? I mean: in the installation process I left the default name NGLARCH, but now I need to change it because of our standards. The OZI version was 3.5 ...
    Andrea Parodi
    last modified by Andrea Parodi
  • How to configure Unload  when using CSV format and the column contents either the terminatedby and enclosedby character?

    Hi all,   We are using BMC unload+ to retrieve some DB2 tables to send to Linux:   UNLOAD UNLOADDN(SYSREC01) CNTLDDN(SYSCTL01) FIXEDVARCHAR YES SYNC 100000 SHRLEVEL CHANGE     ...
    Marcos Hashimoto
    last modified by Marcos Hashimoto
  • How can I get Recovery management for DB2 v11.2 when I see only 12.1 in the installation system?

    How can I get Recovery management for DB2 v11.2 when I see only 12.1 in the installation system? Do I need to fall back to a previous version of the installation system and if so how?
    Deyan Rashev
    last modified by Deyan Rashev
  • Cat Mgr plugging in logical partition number in create table statement instead of physical partition

    Hi, First time user. Am using Cat Mgr V11.01.00 to generate DDL for a table that is using table controlled partitioning on db2 z/os V10.  The DDL command is plugging in the "logical partition" number in the CRE...
    Carl Castrianni
    last modified by Carl Castrianni
  • How to terminate the LOAD utility?

    Hi community members. NGT DB2 load utility V12.01.00 with DB2 V11 abended with code S878 reason 10   U1911. Attempts to RESTART or QUICKEXIT fail with message that INFOPDS is missing. In the load job this ...
    EVGENY ZIABKO
    last modified by EVGENY ZIABKO
  • NGT Webinar Series

    The Customer Success organization is hosting a free NGT Webinar Series.  We have already completed 2 sessions that have been recorded and are available on YouTube.  The upcoming session is on SmartSwitch and...
    Kevin McGuinn
    last modified by Kevin McGuinn
  • BMC AMI-DevOps for Db2 Beta Program Launch

    The BMC AMI-DevOps for Db2 team are in the final stages of preparation for our upcoming introductory beta-program with a European retailer and an American Financial Services company starting in mid-March.   Devop...
    Tony Poole
    last modified by Tony Poole
  • ReOrg Plus : Long running ReOrg job BMC50780I

    Hi,   We have a long running job due to the excessive logs for BMC50780I. The table is highly utilized during the ReOrg phase. Any easier way to bypass the logs for BMC50780I ?   The ReOrg does deletes old...
    Anoop PV
    last modified by Anoop PV
  • DB2 NGT query on parameter +CATCHUP_CYCLES.

    DB2 NGT "Manual says that  CATCHUP_CYCLES is an upper limit of the processing of applying update data. Does it mean LOG APPLY of REORG?  Is this parameter applicable only for NGT REORG and NGT LOAD Resume al...
    Devanand Karunakaran
    last modified by Devanand Karunakaran
  • Has anyone faced Lock escalation on SYSCOLDIST_HIST and SYSCOLUMNS_HIST during REORG? Global Options are RUNSTATS(NO) and we are expecting REORG not to run RUNSTATS. But the REORG job caused lock escalation on these catalog tables.

    Has anyone faced Lock escalation on SYSCOLDIST_HIST and SYSCOLUMNS_HIST during REORG? We have Global Options as RUNSTATS(NO) and we are expecting reorg NOT to run RUNSTATS. Cannot find any information on the CDBPRIN...
    Mohamed Shajahan MKS
    last modified by Mohamed Shajahan MKS
  • Do NGT REORG and LOAD utilities support PRIQTY -1 and SECQTY -1?

    Hi community members. We use NGT for Db2 V12.01.  Some of our table spaces and indexes are defined with parameters PRIQTY -1 and SECQTY -1.  Do NGT REORG and LOAD utilities automatically calculate optimal p...
    EVGENY ZIABKO
    last modified by EVGENY ZIABKO
  • How can I use the DB2 Log Master to read the archive log in another system?

    Hi, I have a problem on using the DB2 LogMaster. I want to use the DB2 LogMaster to read the DB2 archive logs, but It can't be read on the system the DB2 running on. I have to restore these archive logs to another sys...
    zhao lu
    last modified by zhao lu
  • ERROR DURING FREEMAIN of NGT REORG

    Hi community members. I ran REORG utility NGT for DB2 V12.01.00 with parameters REGION=512M, MEMLIMIT=2G. The utility ended OK, however in JESMSGLG this message was produced: IEA705I ERROR DURING FREEMAIN SYS CODE ...
    EVGENY ZIABKO
    last modified by EVGENY ZIABKO
  • Does DB2 NGT Unload utility support SYSIBMADM.GET_ARCHIVE

    We would like to use DB2 NGT Unload utility V12.1 for archive enabled tables. Does the utility support global system variable SYSIBMADM.GET_ARCHIVE?
    EVGENY ZIABKO
    last modified by EVGENY ZIABKO
  • Log Master log processing in DB2 shared environment for objects exclusively in SSID and not shared.

    We are attempting to create REDO SQL for a table.  The DB2 SSID is involved in a shared environment, but is not an object defined to be utilize shared resources (and so is explicit to the Shared SSID, not the gro...
    Vernon Bell
    last modified by Vernon Bell