MainView Data Transformation utility (BBM9MD75) produces this error: BBMMD711E SYSDSN ERROR ON BBACTDEF hlq.BBACTDEF(BBDTDM). Reason=MEMBER NOT FOUND"

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    MainView Infrastructure


    APPLIES TO:

    MainView Infrastructure - version 6.3.00 and above



    QUESTION:

    I have applied PTF BQY2138, which implements the new MainView Data Transformation utility (BBM9MD75), and have found a problem.
    Testing BBM9MD75, I got these messages: 

    BBMMD702I 2 SELECT STATEMENTS READ FROM SYSIN DD 

    ******************************************************* 
    BBMMD703I SELECT STATEMENT NUMBER 1 WAS SKIPPED (RC=8) 
    BBMMD711E SYSDSN ERROR ON BBACTDEF hlq..BBACTDEF(BBDTDM).Reason=MEMBER NOT FOUND 

    ******************************************************* 
    BBMMD703I SELECT STATEMENT NUMBER 2 WAS SKIPPED (RC=8) 
    BBMMD711E SYSDSN ERROR ON BBACTDEF hlq.BBACTDEF(BBUTDM).Reason=MEMBER NOT FOUND 
    READY 
    END 


    I do not see members BBUTDM and BBDTDM in any library.

    Below is the JCL I used for the relevant step. 

    //DUMPXTRT EXEC PGM=IKJEFT01,REGION=0M,PARM=BBM9MD75 
    //STEPLIB DD DISP=SHR,DSN=hlq.BMCLINK 
    //MD73IN DD DISP=SHR,DSN=hlq.HST1DS(+0) 
    //BBACTDEF DD DISP=SHR,DSN=hlq.BBACTDEF 
    //BBSAMP DD DISP=SHR,DSN=hlq.BMCSAMP 
    //SYSTSPRT DD SYSOUT=* 
    //SYSTSIN DD DUMMY 
    //SYSIN DD * 

    * SELECT 1: ADDRESS SPACE RECORD MAP (ASRE) 

    SELECT ASREASID,ASRENAME,ASREJBID,ASREYFL, 
    ASRSLAP,ASRSDUR,ASRSTCB,ASRSSRB,ASRSFMC,ASRSWSS, 
    ASRILAP,ASRIDUR,ASRITCB,ASRISRB,ASRIFMC,ASRIWSS 
    FROM BBDTDM.BBMUCE01 
    WHERE (ASREYFL=01X | ASREYFL=02X) 
    & LCLTIME > 20190101000101.00; 

    * SELECT 2: MOUNTED FILE SYSTEM RECORD MAP (FMRE) 

    SELECT * 
    FROM BBUTDM.BBUUCEC2; 
    //OUT1 DD DSN=hlq.BBM9MD75.OUT1,DISP=(,CATLG), 
    // SPACE=(CYL,(500,100),RLSE),UNIT=SYSDA, 
    // DCB=(LRECL=32000,BLKSIZE=32760,RECFM=VB,DSORG=PS) 
    //OUT2 DD DSN=hlq.BBM9MD75.OUT2,DISP=(,CATLG), 
    // SPACE=(CYL,(500,100),RLSE),UNIT=SYSDA, 
    // DCB=(LRECL=32000,BLKSIZE=32760,RECFM=VB,DSORG=PS)


    ANSWER:

    Recent Technical Bulletin (ID 638) announced this new MainView Infrastructure (MVI) feature: http://documents.bmc.com/supportu/documents/48/77/514877/514877.pdf 

    A link in the TB "For more information, see Transforming historical data (PTF BQY2138 applied)" takes the viewer to a page on our Docs site:
    https://docs.bmc.com/docs/mcdv630/transforming-historical-data-ptf-bqy2138-applied-866902421.html
     
    This page contains a sample job that uses BBACTDEF members that are not yet available at time of writing (May 2019). 

    This sample job will work, once the individual MainView product group responsible (MainView for z/OS, MainView for USS, etc.) has provided in BBACTDEF the necessary members for the MVI utility to use. MVI provides the enabling PTF, while each MainView product group delivers the data maps and TDMs.

    Here is some further explanation.

    =========================================================================================
    The reason the SELECT statements fail is that the TDM and data map members delivered by the MainView product that
    writes the history records are not yet available. In this case, the MainView for z/OS and Mainview for USS members are
    missing, because they have not yet been released and have not been installed.

    Look for new product SPEs or new product releases to deliver the required members. Technical Bulletins will accompany
    each new release of TDMs and data maps. 

    Unfortunately, the examples that appear in the BBM9MD75 documentation are examples we used for testing and will not
    operate until the product data maps and TDMs are installed. 

    MainView for z/OS V6.2 will contain the new TDM and data maps. This product is scheduled for GA around June 2019.
    The other products are in the process of delivering TDMs and data maps, some of which are already available - MVAO,
    MVMQ and MVCICS.
    =========================================================================================

    For more information, see these three TBs announcing the MVAO, MVMQ and MVCICS data maps. 

    (ID 654) Technical bulletin — The MainView AutoOPERATOR table data map is now available
    http://documents.bmc.com/supportu/documents/47/72/514772/514772.pdf

    (ID 656) Technical bulletin — The MainView for CICS table data map is now available
    http://documents.bmc.com/supportu/documents/47/73/514773/514773.pdf

    (ID 650) Technical bulletin — MainView for MQ adds support for product Data Maps
    http://documents.bmc.com/supportu/documents/40/27/514027/514027.pdf


    Article Number:

    000168873


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles