Optim - Test Data Management and Archiving

Expand all | Collapse all

Read optim archive file and dump its data to HDFS (Hadoop)

  • 1.  Read optim archive file and dump its data to HDFS (Hadoop)

    Posted Fri September 17, 2021 11:06 AM
    Hi Team,

    Could you please help me to understand whether can we read data from any archive file and dump its content to HDFS.

    Thank you,
    Rakhi Gour

    ------------------------------
    Rakhi Gour
    ------------------------------


  • 2.  RE: Read optim archive file and dump its data to HDFS (Hadoop)

    Posted Mon September 20, 2021 08:58 AM
    Hi Rakhi,

    Yes, it is possible, please use Optim Load request.

    Regards,
    Tulasi

    ------------------------------
    Tulasi Das Uppu
    ------------------------------



  • 3.  RE: Read optim archive file and dump its data to HDFS (Hadoop)

    Posted Mon September 20, 2021 09:05 AM
    Hi Tulsi,

    So your suggestion would be, create dbalias for hdfs db and then use normal optim load. 
    Could you please also help me to understand whether can we use pr0hdfs utility and its usage, also is there any documentation regarding it.

    Thank you,
    Rakhi Gour

    ------------------------------
    Rakhi Gour
    ------------------------------



  • 4.  RE: Read optim archive file and dump its data to HDFS (Hadoop)

    Posted Mon September 20, 2021 12:53 PM
    Hi Rakhi,

    Create ODBC DSN for Hive Server, create Dbalias then create Optim load request. Technote link https://www.ibm.com/support/pages/system/files/inline-files/$FILE/Optim-Hadoop-Hive-Technote.pdf.

    When you run the load request, it will going to use pr0hdfs.

    For more details about pr0hdfs, just run rt/bin/pr0hdfs, you will get it's usage.

    Regards,

    ------------------------------
    Tulasi Das Uppu
    ------------------------------