Skip to main content

DB Utilities for Microfocus

  • April 3, 2020
  • 2 replies
  • 0 views
D

We are migrating from Mainframe to Microfocus. 

We have DSNUTILB in Mainframe to load and unload the data. Apart from this the utility is used for tablespace maintenance like Runstats, Repair, Check data, QUIESCE etc.

Similar to DSNUTILB, we have found SQLUTB utility in Microfocus with which we can load and unload data. But I am not able to use Runstats, Repair, Check data, QUIESCE with SQLUTB as I am getting error -> these commands are not supported.

Kindly help me with any utility in Microfocus with which we can execute tablespace maintenance commands. Target DB -> Postgres

Thanks in advance.


#EnterpriseDeveloper

    2 replies

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • April 6, 2020

    We are migrating from Mainframe to Microfocus. 

    We have DSNUTILB in Mainframe to load and unload the data. Apart from this the utility is used for tablespace maintenance like Runstats, Repair, Check data, QUIESCE etc.

    Similar to DSNUTILB, we have found SQLUTB utility in Microfocus with which we can load and unload data. But I am not able to use Runstats, Repair, Check data, QUIESCE with SQLUTB as I am getting error -> these commands are not supported.

    Kindly help me with any utility in Microfocus with which we can execute tablespace maintenance commands. Target DB -> Postgres

    Thanks in advance.


    #EnterpriseDeveloper
    For functions like this, your DBA should use the utilities and other mechanisms and procedures appropriate for the DBMS you are using (Postgres in your case). Database maintenance, broadly speaking, is specific to each DBMS and not a Micro Focus function.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • April 7, 2020
    For functions like this, your DBA should use the utilities and other mechanisms and procedures appropriate for the DBMS you are using (Postgres in your case). Database maintenance, broadly speaking, is specific to each DBMS and not a Micro Focus function.

    Thank you for your reply. 

    But SQLUTB is the utility provided by Microfocus as a solution to load and unload as per the below link

    https://www.microfocus.com/documentation/enterprise-developer/ed50/ED-Eclipse/GUID-4773240E-A694-4354-B156-B3AAF5BE3DAF.html

    Hence thought of asking if any other utility present for the tablespace maintenance commands.


    Terms & ConditionsAccessibility statement