NonStop Servlets for JavaServer Pages (NSJSP) 6.1 System Administrator's Guide

Configuring NSJSP
NonStop Servlets for JavaServer Pages (NSJSP) 6.1 System Administrator’s Guide—596210-006
3-93
Determining the Storage Capacity of the Persistent
Store
shows the sample output of a showddl command.
2. Use the fup info <filename>,detail command at a TACL prompt to display
the current size of the file. Example 3-74 shows the sample output of a fup info
<filename>,detail command.
Example 3-73. The Sample Output of a showddl Command
>>showddl nsjspcat.nsjspsch.sessdata;
CREATE TABLE NSJSPCAT.NSJSPSCH.SESSDATA
(
SESSION_ID CHAR(48) CHARACTER SET ISO88591
COLLATE
DEFAULT NO DEFAULT -- NOT NULL NOT DROPPABLE
, PROCESS_NAME CHAR(8) CHARACTER SET ISO88591
COLLATE
DEFAULT NO DEFAULT -- NOT NULL NOT DROPPABLE
, REC_NUMBER INT UNSIGNED NO DEFAULT
-- NOT NULL NOT DROPPABLE
, VALID SMALLINT UNSIGNED NO DEFAULT
, MAXINACTIVEINTERVAL INT NO DEFAULT
, LASTACCESSED LARGEINT NO DEFAULT
, APP_NAME VARCHAR(150) CHARACTER SET
ISO88591
COLLATE DEFAULT NO DEFAULT -- NOT NULL NOT DROPPABLE
, SESSION_DATA VARCHAR(3600) CHARACTER SET
ISO88591
COLLATE DEFAULT DEFAULT NULL
, CONSTRAINT NSJSPCAT.NSJSPSCH.SESSDATA_279712597_5623 PRIMARY KEY
(SESSION_ID ASC, PROCESS_NAME ASC, REC_NUMBER ASC) NOT
DROPPABLE
, CONSTRAINT NSJSPCAT.NSJSPSCH.SESSDATA_385269497_5623 CHECK
(NSJSPCAT.NSJSPSCH.SESSDATA.SESSION_ID IS NOT NULL AND
NSJSPCAT.NSJSPSCH.SESSDATA.PROCESS_NAME IS NOT NULL AND
NSJSPCAT.NSJSPSCH.SESSDATA.REC_NUMBER IS NOT NULL AND
NSJSPCAT.NSJSPSCH.SESSDATA.APP_NAME IS NOT NULL) NOT DROPPABLE
)
LOCATION \POS02.$DATA00.ZSDG8WWM.JM2SKH00
NAME POS02_DATA00_ZSDG8WWM_JM2SKH00
STORE BY (SESSION_ID ASC, PROCESS_NAME ASC, REC_NUMBER ASC)
;