Running the ParquetMigrate utility

Use the ParquetMigrate utility to apply the new Parquet format to uploaded files and data sets from IBM® Cognos® Analytics with Watson 11.0.x. When used with its option m, this utility also retrieves the deeper data characteristics from uploaded files and data sets.

The Parquet format that is used to store data in uploaded files and data sets has changed between Cognos Analytics versions 11.0.x and 11.1. Run the ParquetUpgrade command before users start running dashboards and reports. This ensures that all workloads immediately benefit from performance gains of the new format. If a query uses data that wasn’t upgraded, the query service internally initiates the upgrade and the users experience a one-time performance degradation when they run the dashboards, stories, reports, or explorations in Cognos Analytics 11.1. Subsequent queries use the upgraded data.

The ParquetMigrate command supports the following parameters:

-h URL: The URL to an active Cognos Analytics server. When you don't specify the URL, the URL that is configured in Cognos Configuration on the computer from which the command is run is used.
-n Namespace: The namespace to authenticate into when connecting to the Cognos Analytics server.
-u User name: The user name to authenticate with when connecting to the Cognos Analytics server.
-p Password: The password to use for authentication to the Cognos Analytics server.
-d: Displays information about the uploaded files and data sets in the content store. No objects are upgraded.
-k: Ignores the SSL certificate validation. You can use this parameter when running the script in Cognos Analytics with SSL configured. However, you might not need this parameter if the SSL certificate is imported into the keystore of the Java that is used when you run the ParquetMigrate utility. For information about importing certificates, see Import the certificate authority (CA) certificates.
-l: Applies only to the last used files.
-t: Filters displayed results by task ID. Use this parameter only with the -d parameter.
-s: Specifies the store ID. The command is applied to the hierarchy, starting with the provided content store ID.
-m: Retrieves the deeper data characteristics in Cognos Analytics. For more information, see Data upgrade tasks for Cognos Analytics
-a: Smarts version upgrade only.

Procedure

Open the command line utility, and navigate to the cognos_analytics_location\bin64 directory.
Run the ParquetMigrate.bat (Windows) or ParquetMigrate.sh (Unix) utility. The following examples are the commands that you can run:
To display information about uploaded files or data sets, use the following command:
```
ParquetMigrate -d -n namespace -u user_name -p password
```
Or
```
ParquetMigrate -d -h http://cognos_analytics_host:9300 -n namespace -u user_name -p password
```
To upgrade files or data sets, use the following command:
```
ParquetMigrate -n namespace -u user_name -p password
```
To upgrade files and data sets, and at the same time retrieve the deeper data characteristics, use the following command:
```
ParquetMigrate -m -n namespace -u user_name -p password
```
Run the command.

Results

When the command completes, the number of upgraded objects is displayed. A value of 0 indicates that no objects requiring upgrade were found.