Datacom

 View Only

  • 1.  Record Growth

    Posted Jul 21, 2011 08:34 AM
    Afternoon ,

    Two Questions please :

    1/ Is there any method out there to show the record growth of certain Datacom tables ? ( Besides cxx reports )

    2/ Does anyone have a workable solution to do real time synchronizing from Datacom DBMS on Z/os to a Oracle DBMS on Linux ?
    We do it currently with MQ Series but are looking for a better / quicker option ???

    Thx




    ************************************************************************************************************************************************************************

    The information in this e-mail and any attachments transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please delete it and notify the system manager or the sender. Any agreements, views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of the DOD. The DOD accept no liability for any loss or damages caused by any malicious code transmitted by this e-mail.
    ************************************************************************************************************************************************************************


    --=_alternative 0044E8BA422578D4_=


    <br><font size=2 face="sans-serif">Afternoon ,</font> <br> <br><font size=2 face="sans-serif">Two Questions please :</font> <br> <br><font size=2 face="sans-serif">1/ Is there any method out there to show the record growth of certain Datacom tables ? ( Besides cxx reports )</font> <br> <br><font size=2 face="sans-serif">2/ Does anyone have a workable solution to do real time synchronizing from Datacom DBMS on Z/os to a Oracle DBMS on Linux ?</font> <br><font size=2 face="sans-serif">We do it currently with MQ Series but are looking for a better / quicker option ???</font> <br> <br><font size=2 face="sans-serif">Thx</font> <br> <br> <br><font size=2 face="sans-serif"> </font>

    ************************************************************************************************************************************************************************

    The information in this e-mail and any attachments transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please delete it and notify the system manager or the sender. Any agreements, views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of the DOD. The DOD accept no liability for any loss or damages caused by any malicious code transmitted by this e-mail.
    ************************************************************************************************************************************************************************


    --=_alternative 0044E8BA422578D4_=


  • 2.  Re: Record Growth

    Posted Jul 21, 2011 09:53 AM
    Message-ID: :love:28D1D477D51BE468E721F3A11D28354098927F6@EXMBPR13.na.mmfg.net>

    On #1: Once a month we capture statistics from DIR_DATASET (system
    table) into a historical table. That allows us to see growth over time =66or each area. If you're more interested in numbers of records by table you could take snapshots from DIR_TABLE. =20

    INSERT INTO OPR_DATASET =20
    SELECT CURRENT DATE, =20
    DBID, AREA_NAME, =20
    TOTAL_TRACKS, TOTAL_BLOCKS, MAX_USED_BLOCKS, IN_USE_BLOCKS,
    PARTIAL_BLOCKS =20
    =46ROM DIR_DATASET =20


    Original Message