LPL means "The tablespace, tablespace partition, index, index partition, or logical index partition has logical page errors."
You will need to have authority to fix this (understandably).
Display all the objects that are in this status via:
-DIS DATABASE(dbname) SPACENAM(*) LPL ONLY
START DATABASE(dbname) SPACENAM(spname) ACCESS(RW)
...should cause DB2 to automatically fix this problem.
Repeat the -DIS command to verify.
You will require the following:
- VTAM entry for db2 subsystem
- VTAM entry activated
Must set up nnnnDIST and nnnnSPAS regions for each subsystem.
Must change ZPARM module to add STORPROC=nnnnSPAS and DDF=AUTO and MAXTYPE1=2. Also TCPALVER=YES to start with.
Must update the BSDS with a new DDF record with PORT= port number above and RESPORT= resync port number above. These numbers were chosen at random and are not below 1024, which are generally reserved by MVS. VTAM addresses!
Allocate TCPIP port numbers for the DRDA and RESYNC ports. Update the TCPIP profile with reservations for these numbers. This is not strictly necessary if the numbers are above 1024.
Note the TCPIP home address, from the profile.