AE_TEMPLOCK2_VW

index back

Tebl Tbl Locks by Pgm & Tbl

Tracks how many Temporary Table instances are locked by AE_APPLID and table name
SELECT RECNAME , AE_APPLID , COUNT(*) FROM PS_AETEMPTBLMGR WHERE CURTEMPINSTANCE > 0 GROUP BY RECNAME , AE_APPLID

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
TEMPTBLINSTLOCKS Number(4,0) SMALLINT NOT NULL Used to track how many instances of a particular temporary table are locked/in use at the moment.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19