DB2

Tip: Object in Restricted Access status indicating LPL

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.

DB2

DB2 related pages

more DDF notes

You will require the following:

  • VTAM entry for db2 subsystem
  • VTAM entry activated

DDF notes

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!

DB2 and TCPIP

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.

MyMusic