To test long file names

1. Log on to the IBM i as QSECOFR.

2. On the command line, enter STRSQL.

   This command starts a SQL session on the IBM i.

3. Enter this SQL statement:

   CREATE TABLE QGPL/ <LONGFILENAME> (FIELD CHAR (10))

   Where <LONGFILENAME> is the name of the file. The system is ready if the file is created in the QGPL library. You can ignore the journal setting.

4. Enter this SQL statement to remove the file that you just created in the QGPL library,

   DROP TABLE QGPL/ <LONGFILENAME>

   Note:

   The remaining steps in this procedure, Steps 5 through 8 below, are only required if Step 3 above fails.

5. Stop all subsystem jobs from console, (ensure no users are on the system when stopping subsystem jobs).

6. After the jobs have successfully stopped, run this command:

   RCLSTG SELECT(*DBXREF)

   Note that this command might run for several hours.

7. Restart all subsystem jobs by IPL or by starting each subsystem.

8. Verify that the cross-reference tables are built by entering these SQL commands:

   SELECT * FROM SYSTABLES

   SELECT * FROM SYSCOLUMNS