Printing the contents of DB2 SQLJ profiles (db2profp and profp)

The DB2® SQLJ Profile Printer, db2profp, prints the contents of a DB2 customized profile in plain text. The Profile Printer, profp, prints the contents of profiles generated by the SQLJ translator in plain text.

To print the content of the profiles generated by the SQLJ translator in plain text, use the profp utility as follows:

     profp MyClass_SJProfile0.ser

Where MyClass_SJProfile0.ser is the name of the profile you want to print.

To print the content of the DB2 customized version of the profile in plain text, use the db2profp utility as follows:

     db2profp MyClass_SJProfile0.ser

Where MyClass_SJProfile0.ser is the name of the profile you want to print.

Note: If you run db2profp on an uncustomized profile, it tells you that the profile has not been customized. If you run profp on a customized profile, it displays the contents of the profile without the customizations.

DB2 SQLJ Profile Printer usage and syntax:

     db2profp [options] <SQLJ_profile_name>

Where SQLJ_profile_name is the name of the profile to be printed and options is the list of options you want.

The options available for db2profp are the following:

-URL=<JDBC_URL>

Where JDBC_URL is the URL you want to connect to. For more information, see Accessing your IBM i database with the Java JDBC driver.

-user=<username>

Where username is the user name is your user profile.

-password=<password>

Where password is the password of your user profile.