through several syslogd error messages output to the monitor or a failed attempt at restarting the failed conversion program. Should DB2 be placed in an inconsistent state, the tablespace will likely have to be dropped and recreated along with the table being converted. Then the database will need to be recycled (using db2stop and db2start).
Note that the long running conversion programs are started from a script that will call a C program to read metadata from SFS, convert the data, and write the data to a named pipe. The script then issues the DB2 load command which reads from the named pipe. To ensure correctness of the metadata converted, the number of records submitted to the load from the C program should equal the number of committed rows by the load utility. Output for a successful conversion will look like the following:
Running lr_db_convert_nsobject utility...
Converting SFS file /.:/encina/sfs/hpss/nsobjects.1.................
Converted 103749 records successfully from /.:/encina/sfs/hpss/nsobjects.1
lr_db_convert_nsobject complete, submitted 0 records to DB2 nsacl load for subsystem 1
lr_db_convert_nsobject complete, submitted 103749 records to DB2 nsobject load for subsystem 1, 1870 operations per sec, 55.455049 total time
Number of rows read | = 103749 |
Number of rows skipped | = 0 |
Number of rows loaded | = 103749 |
Number of rows rejected | = 0 |
Number of rows deleted | = 0 |
Number of rows committed | = 103749 |
Notice that the number of rows committed by the load (103749) is equal to the C program's number of rows submitted to the load (103749). If the numbers do not agree or any deleted, skipped or rejected rows are encountered, the conversion program has not converted the metadata correctly. In this case, contact your HPSS customer support representative.
In the case that you have already run a long running conversion and it failed, follow restart procedures in Section 6.3.13.5: Restarting the Long Running Utilities on page 207. The output upon restart should look like the following:
Converting SFS file /.:/encina/sfs/hpss/nsobjects.1......
Converted 103749 records successfully from /.:/encina/sfs/hpss/nsobjects.1
lr_db_convert_nsobject complete, submitted 0 records to DB2 nsacl load for subsystem 1
lr_db_convert_nsobject complete, submitted 103749 records to DB2 nsobject load for subsystem 1, 1870 operations per sec, 55.455049 total time
Number of rows read | = 103749 |
Number of rows skipped | = 0 |
Number of rows loaded | = 103749 |
Number of rows rejected | = 0 |
Number of rows deleted | = 0 |
Number of rows committed | = 103749 |
HPSS Installation Guide | July 2008 |
Release 6.2 (Revision 2.0) | 233 |
