You are here: LANSA for i User Guide > 5. Housekeeping > 5.6 Reorganizing the LANSA Internal Database > 5.6.5 Remotely Invoke the Reorganization Facility

5.6.5 Remotely Invoke the Reorganization Facility

To invoke the Reorganize job remotely, or to include it in existing end of day/week jobs or with one of the automatic job scheduling facilities, you can do so using variations of the LANSA command or by calling the LANSA entry point program like this:

LANSA REQUEST(REORG)

or

LANSA REQUEST(REORG) PARM01(Y) PARM02(99) PARM03(20)

or

LANSA REQUEST(REORG) PARM01(Y) PARM02(99) PARM03(20) PARM04(N) PARM05(CCYYMMDD)

 

Note that two conditions apply when you run this job:
You will need the profile of a security officer/partition security officer of QOTHPRDOWN or a security officer in that group.
and
No job should be accessing LANSA.

If you prefer manually submit the Reorganize job, refer to 5.6.4 Submit Job to Reorganize the Database.

For details of the parameters used with this command, refer to 5.6.4 Submit Job to Reorganize the Database:

PARM01

Change Work Spaces  (PARM01)

PARM02

Total FFC  (PARM02)

PARM03

Total Compiles  (PARM03)

PARM04

Remove Multilingual Support  (PARM04)

PARM05

Purge Developer Messages Starting from Date  (PARM05)

PARM06

Delete Deleted Partition Language Extensions  (PARM06)

PARM07

Reorganize Shared LANSA system files  (PARM07)

PARM08

Purge Task History Starting from Date  (PARM08)

PARM09

Remove deleted users from LANSA files  (PARM09)