4. Operation › 4.5 Integrating CA MICS Data to NSM › 4.5.3 Data Conversion and Transfer

4.5.3 Data Conversion and Transfer

After CSV data for NSM Performance Trend or NSM Chargeback
have been extracted from the CA MICS database, they need to
be downloaded to the NSM machine where NSM Systems
Performance is installed.  Furthermore, CSV data for
Performance Trend must be converted into the Performance Cube
format before they can be processed.

The RMWSXFR program supports CSV data conversion and data
transfer.  To install a copy of RMWSXFR on your workstation,
complete the following checklist:

___ 1.  Download TNGXFRZ from sharedprefix.MICS.BIN.

        To use FTP (File Transfer Protocol) to transfer
        TNGXFRZ to your Microsoft Windows Workstation,
        perform the following steps in order:

        ___ a.  Open a DOS command window.

        ___ b.  Start the FTP program using the following:

                FTP <hostname>

                where <hostname> is the machine name or the
                IP address of the OS/390 system.

                Supply the host userid and password as
                prompted.

        ___ c.  Set binary transfer mode by entering the
                following command (in lower case):

                binary

        *****************************************************
        *  NOTE:  This FTP command and those to follow      *
        *         must be entered in lower case.            *
        *****************************************************

        ___ d.  Set the name of the host data set with the
                following:

                cd 'sharedprefix.MICS.BIN'

        ___ e.  Set the directory name of the workstation
                directory to hold TNGXFRZ with the following
                command:

                lcd <directory>

                where <directory> is a directory on the
                workstation which will contain TNGXFRZ.
                Generally, this is a temporary or working
                directory (e.g. C:\TEMP).

        ___ f.  Transfer the TNGXFRZ to the workstation with
                the following command:

                get TNGXFRZ RMWSXFRZ.EXE

                This will copy TNGXFRZ to the directory
                specified in step e and rename it to
                RMWSXFRZ.EXE.

        ___ g.  Once the transfer is complete, exit FTP by
                entering:

                quit

        While this example uses FTP to perform the actual
        transfer, other utilities (such as IND$FILE) can be
        used.  Whichever program will be used, it must be
        able to transfer from the host to the workstation
        without performing any character translation (i.e.
        EBCDIC to ASCII).

___ 2.  Run RMWSXFRZ.EXE.  This starts the installation
        process.  You will be prompted for a destination
        folder where the program files will be installed.

___ 3.  After the installation is complete, read README.TXT
        in the program directory for detailed instructions
        on how to use RMWSXFR.