• I need certificate to use Receive Order process.  Do I need to open a case?

    I'm trying to download a PTF from the BMC website and am receiving the following msg: smpeCC:09 smpeRoutine:GIMJVCNI smpeMsgLen:0000000110 smpeMsg:java.io.IOException  : The private key of mft.bmc.com is not a...
    Roger Plihal
    last modified by Roger Plihal
  • What are the correct actions that should be specified in the HOLD DATA for EXECUTION for DB2 PTFs BQU2324 and BQU2580?

    We do not have a hlq.UBMCCNTL(AEXFLVL) member.   Thank you.
    LANA CHRISMAN
    last modified by LANA CHRISMAN
  • DB2 Coffee Talk - over 125 attendees!

    Wednesday's DB2 Coffee Talk - DB2 Copy - BMC Style was a great success.  Over 125 attendees with quite a bit of interaction over the Chat.   The session was recorded, so if you missed it or had to drop ...
    Mike Donaldson
    created by Mike Donaldson
  • BMC50049W BMCSORT LICENSE WILL EXPIRE SOON. CALL BMC SUPPORT Message may appear after June 1, 2020

    In March 2017 and again on June 1 2017, customers were notified of an upcoming condition that BMCSORT 2.4.01 components license would expire on 7/1/2017.  This caused jobs to issue a RC=4 along with the BMC50049W...
    Mike Donaldson
    created by Mike Donaldson
  • New DBA @ the job

    Change Manager z/os Db2 environment.  When I try to create a Work Id and go thru the process of Performing a Migrate in the Analysis phase wants to use the BMC Reorg utility.  But we don't have BMC we have I...
    Matthew Osterkamp
    last modified by Matthew Osterkamp
  • 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