IMS Tools

Expand all | Collapse all

Secondary index Builder vs 8Gb Databases

  • 1.  Secondary index Builder vs 8Gb Databases

    Posted 07-10-2020 05:32 PM

    Secondary index Builder : 8GB HALDB OSAM support.

    We do need this urgently for the following reasons :


    We have huge IMS databases used in after sales activity (The most beneficial one in automotive industry) which must be extended to 8 Gb.

    If SIU do no support this option, we'll have the choice between 2 equally inacceptable solutions :

    • Keep the size as it is (4 Gb) and reorganize the databases every 2 weeks), which generates service outages and is utterly inacceptable for the business.
    • Extend their size to 8 Gb and do not reorganize them any more because SIU won't be able to handle such databases.

    For the time being we have chosen the first option, but our business won't accept this situation much longer, especially when the corresponding IBM product supports this facility.


    We have other IMS databases which are growing significantly, which means we'll need this facility on a larger scale. The big data also exists on mainframe, in DB2 and IMS databases.

    One last thing : This 8 Gb support existed since IMS V14. The current IMS version is 15.2. All the Broadcom IMS-related tools should have been updated accordingly several years ago.

    Best regards


  • 2.  RE: Secondary index Builder vs 8Gb Databases

    Broadcom Employee
    Posted 07-14-2020 02:51 AM
    Hi Jean Claude,

    thank you for your note. It is my pleasure to let you know that we have pushed this requirement to our backlog. Should you want to stay in touch to get more information, please feel free to contact me on my email: We will post the update if the deliverable is done.


    Jakub Hofman

  • 3.  RE: Secondary index Builder vs 8Gb Databases

    Posted 07-25-2020 03:29 PM
    RE: IMS HALDB Utilities vs 8GB Databases
    We, at DXC Technology / United Airlines account have had this need for CA IMS DB Utilities to support the HALDB OSAM 8GB
    for several years.    Our largest HALDB database, now at 128 partitions, keeps growing.     Instead of growing at the 97 parts we once had,
    we have to keep splitting the current parts in order to grow within the HALDB OSAM 4GB limit as the CA IMS utilites ( Copier, Organizer, SIU )
    do not support the 8GB OSAM dataset IMS HALDB has had available.

    We have had to keep going thru the split process, introducing some minor risk by adding the next part# to DBRC as well as adding to the IMS objects and job schedules/parms.

    We very much champion that Broadcom IMS related tools should be updated to support HALDB OSAM 8GB !!

    All the best,

    Lesley Rowe
    Sr. Database Administrator

    DXC Technology

    DBA-IMS and DB2
    DXC Technology

  • 4.  RE: Secondary index Builder vs 8Gb Databases

    Broadcom Employee
    Posted 07-27-2020 01:54 AM
    Hi Lesley,

    thank you for taking time to contribute this thread. Currently, our tools support the 8 GB OSAM HALDB in Database Analyzer - for:
    ANALYZE and ANALYZEALL (allows you to check database integrity and related indexes);
    DISPLAY and ZAP (allows you to display and update blocks in the Database Surgeon component).
    Support in DBO is in development now and SIB is in the development backlog.
    May I suggest to get in touch, my email is


    Jakub Hofman

  • 5.  RE: Secondary index Builder vs 8Gb Databases

    Broadcom Employee
    Posted 01-25-2021 07:15 AM

    Hello  @JEAN CLAUDE LEMONNIER and  @Lesley Rowe

    The CA IMS Tools team is happy to announce that SIB support for 8 GB OSAM HALDBs has been completed (PTF SO14973) and that as of last week CA Database Copier™ for IMS for z/OS has been enhanced to support 8 GB OSAM data sets in HALDBs as well through SO16207, SO16208, for the following functions:

    • COPY
    • COPYIC
    • ACOPY
    • IICOPY



    Product Owner,



  • 6.  RE: Secondary index Builder vs 8Gb Databases

    Broadcom Employee
    Posted 03-11-2021 05:35 AM

    Extending the 8 GB OSAM HALDBs support even further, CA High Performance Recovery for IMS for z/OS now supports 8GB OSAM data sets in HALDB databases.

    The enhancement includes support for the RECOVER function for HPR and the CHACCUM function for the Change Accumulation component and can be installed through LU00468 and LU00469.