Log Analyzer Control Statements

Overview of the control statement syntax and control cards to generate reports, SQL statements, and load files.
Control statements are used to issue commands to the
. A group of control statements is also known as a control card or input card. Default values for many of the control statement parameters are set in the profile panels.

Syntax Notation

The following notation describes the syntax for the control cards.
Uppercase characters
Uppercase characters indicate variables and parameters that
Log Analyzer
specifies. Enter uppercase characters as shown.
Lowercase characters
Lowercase characters indicate variables that you can specify.
( )
Parentheses contain
Log Analyzer
and user-specified variables. Include parentheses where shown.
|
A pipe indicates an OR condition.
[ ]
Brackets identify optional arguments. Do not include
[]
(brackets) in your syntax.
{ }
Curly brackets are visual aids to delimit blocks of parameters, variables, and user-specified variables from other blocks of variables, parameters, and user-specified variables. Do not include
{}
(curly brackets) in your syntax.
The control statement list uses the same naming conventions as the IBM
DB2 Command and Utility Reference Guides
.

Control Card

This section describes the control card syntax.
Control statements are listed in their order of appearance when you generate the JCL to submit for the job. All control statements that start with a period (for example, the
.ALLOC
statement) are
commands. All control statements between the
.DATA
and the
.ENDDATA
statements are
Log Analyzer
control statements.
{{
Batch Processor Data Set Allocation Commands
} .CALL LOG .DATA SSID = (
SSID
) {[STRATEGY = (
ssid,strategy-creator,strategy-name
, SAVE,RETAIN(
nn
,SCRATCH))] {
Start and End Log Processing Range
} LOGLABEL = ([
creator
.]
name
[,DESC(
description
)]) {
Log Processing Parameters
} [DMLREPT = ({
DML Activity and DML Update Report Parameters
})] [DMLUPDT = ({
DML Activity and DML Update Report Parameters
})] [CMDREPT = (FORMAT (REPORT|CSV) ,OPTS (YES|NO))] [COMREPT = ({
Commit Frequency Report Parameters
})] [ICREPT = ({
Image Copy Frequency Report Parameters
})] [RBREPT = ({
Rollback Activity Report Parameters
})] [RECOREPT= ({
Recovery Point Analysis Report Parameters
})] [DDLREPT = ({
DDL Activity Report Parameters
})] [CDCREPT = {
Change Data Capture Analysis Report Parameters
})] |{[DOTREPT = (TABLES (
creator1.name1,creator2.name2
,...))]} EXTRACT = (FILTER|ALL|NO)} |{
Start and End Log Processing Range
} LOGLABEL = ([
creator
.]
name
[,DESC(
description
)]) QPAREPT = ({
Quiet Point Analysis Report Parameters
}) .ENDDATA {
Batch Processor Data Set Release Allocation Commands
}}
  • When you use the
    DMLREPT
    and
    DMLUPDT
    control statements together, you must specify both control statements with the the same report parameters.
  • You cannot use the
    DOTREPT
    control statement with the other reports.
  • You cannot use the
    QPAREPT
    control statement with the other reports or strategies.

Additional Parameter and Command Options

This section describes the expanded syntax for selected control statements:
Batch Processor Data Set Allocation Commands
The following commands allocate the data sets necessary to execute
Log Analyzer
:
.ALLOC FI(LADXTRCT)... {
Allocation Options
} .ALLOC FI(LADXCNTL)... {
Allocation Options
} .ALLOC FI(LADREPT)... {
Allocation Options
} .ALLOC FI(LADLOAD)... {
Allocation Options
} .ALLOC FI(LADSQL)... {
Allocation Options
} .ALLOC FI(LADDDL)... {
Allocation Options
} .ALLOC FI(LADDISC)... {
Allocation Options
} .ALLOC FI(LADLOB)... {
Allocation Options
}
For a complete list of the allocation options, see the
Database Management Solutions for Db2
documentation.
Start and End Log Processing Range Control Statements
The following control statements determine the log range of the records to process:
START = (DATE(
yyyy-mm-dd
),TIME(
hh:mm:ss.mmmmmm
)|RBA(
hex-rba
)|LRSN(
hex-lrsn
)|TIMESTAMP|CURRENT|
expression
|LOGLABEL([
creator
.]
name
[(
version
)])) END = (DATE(
yyyy-mm-dd
),TIME(
hh:mm:ss.mmmmmm
)|RBA(
hex-rba
)|LRSN(
hex-lrsn
)|TIMESTAMP|CURRENT|
expression
|LOGLABEL([
creator
.]
name
[(
version
)]))
Log Processing Control Statements
The following control statements specify the parameters to use for log processing:
[RESUME = (
nnn
)] LOGSRC = (
BSDS
|EXTRACT|GROUP|MEMBER(
member-name
)[,MEMBER(
member-name2
),...]|ARCHIVE,
dataset-name
,VOLSER(
vol1
,
vol2
,...),UNIT(
unit
),MEMID(
id
) |ACTIVE,
dataset-name
,VOLSER(
vol1
,
vol2
,...),UNIT(
unit
),MEMID(
id
)) OBJSRC = (
CATALOG
|DDLFILE(
subsystem-name
)|MERGED(
subsystem-name
)) COPYSRC = (
CATALOG
|BOTH|ICMAPS) ICGROUP = (
creatorgrp1
,
namegrp1
,
creatorgrp2
,
namegrp2
,...) ICMAP = (
creatormap1
,
namemap1
,
creatormap2
,
namemap2
,...) DDLFILE = (
map-creator
,
map-name
) DYNSORT = (DSNUM(nn),SPACE(nnn,nnn),MAINSIZE(nnnnn),MSG(Y|
N
)) GENUNIT = (
unit
) RPTLINES = (
nn
) S99WAIT = (
YES
|NO) RESOLVUR = (
END
|START|BOTH|NO) WORKLOAD = (SMALL|MEDIUM|LARGE) UPPRCASE = (YES|
NO
) PURSRC = (AFTER|
BEFORE
|AUTO)
DML Activity Report and DML Update Report Parameters
Use the following parameters to specify how to generate the DML Activity and DML Update reports:
LEVEL(SUMMARY|DETAIL|TOTAL|KEY|IMAGCOPY) ,ROLLBACK(INCLUDE|EXCLUDE|ONLY) ,CATALOG (INCLUDE|EXCLUDE) ,UNDEFTB (INCLUDE|EXCLUDE) ,LOBDATA (INCLUDE|EXCLUDE) ,XMLDATA (STRING |EXCLUDE) ,DSNDB01 (INCLUDE|EXCLUDE) ,OPTS (
YES
|NO) ,ORDERBY (URID|AUTHID|PLAN|TABLE|KEY|KEYUN|REDO|UNDO) ,FORM (
creator
,
form
) ,REPOSTRY (YES|NO) [{,FLTREXPR (
filter
expression
)}|{INCLUDE|EXCLUDE(AND|OR ,PLAN(
plan-name1
,
plan-name2
,...) ,TABLE(
table1
,WHERE(
query1
),APPLY(REDO|UNDO|BOTH),
table2
,...) ,DBNAME(
database1
,
database2
,...) ,AUTHID(
authid1
,
authid2
,...) ,CORRID(
correlation-id1
,
correlation-id2
,...) ,CONNID(
connection-id1
,
connection-id2
,...) ,STTYPE(inserts|deletes|updates|utilities) ,URID(
urid1
,
urid2
,
urid3
,...) )}] ,KEYCOLS(
table1
(
col1
,
col2
,
col3
...) ,
table2
(
col1
,
col2
,
col3
...) ) ,DISCARDS(
nnnnnnnnn
) [{,GENSQL(REDO|UNDO ,COMMIT(
nnnnnnnnn
|BYUR)/*Default:50 ,AUTHID(
blank
|
primary-id
) ,RI(YES|
NO
) ,TRIGGER(
YES
|NO) ,HISTTAB(YES|
NO
) ,SQLONLY(YES|NO) ,URHEAD (YES|
NO
) [,TBMASK(SRC(
creatormask
.
tablemask
) ,TARG(
creatormask
.
tablemask
) )...]) } |{,GENFILE(FIXED|VARIABLE ,UTILITY(LOAD|APPLY|FLOAD) ,COMMIT(
nnnnn
) ,APPLY(REDO|UNDO) ,TBFILES(YES|NO) ,EMPTY(YES|NO) ,DISCARDS(
nnnnnnnnn
) ,LOBROWID(ASIS|OMIT|VARCHAR) ,INCLUDE(REDO,UNDO,AUTHID,CORRID,TIMESTMP PLAN,URID,EURID,URSTATUS,LOGRBA,ELOGRBA CONNID,CONNTYPE,UPDTIND ,LADFILE(
dataset-name
, ,SPACEPCT(
primary
,
secondary
) ,UNIT(
unit
) ,VOLSER(
vol
,
vol
...) ,STORCLAS(
storage-class
) ,MGMTCLAS(
management-class
) ,DATACLAS(
data-class
) ,LABEL(
label
) ,VOLLIMIT(
vollim
) ) ,COLPRFX(
xxxxxxxx
) ,TARGSSID(
ssid
) ,LOG(YES|NO) ,SYSDISC(
primary
,
secondary
) ,SYSERR(
primary
,
secondary
) ,SYSMAP(
primary
,
secondary
) ,SYSUT1(
primary
,
secondary
) ,SORTOUT(
primary
,
secondary
) ,TBMASK(SRC(
creatormask
.
tablemask
) ,TARG(
creatormask
.
tablemask
) ) [,TBMASK(SRC(
creatormask
.
tablemask
) ,TARG(
creatormask
.
tablemask
) )...] }] ,SUBSUPD(DETAIL|SUMMARY ,END = (CURRENT|DATE(
date
),TIME(
time
)|RBA(
rba
)|LRSN(
lrsn
)) ) ,HEXDATA(YES) )
Restrictions:
  • GENFILE
    and
    GENSQL
    are valid only with
    LEVEL(IMAGCOPY|DETAIL)
    .
  • GENFILE
    and
    GENSQL
    cannot be used together.
  • FLTREXPR
    cannot be used with the
    INCLUDE
    or
    EXCLUDE
    filters.
Commit Frequency Report Parameters
Use the following parameters to specify how to generate a Commit Frequency Report:
LEVEL(SUMMARY|DETAIL) ,UPDATES(
commit-threshold
) ,INCLUDE|EXCLUDE( ,PLAN(
plan-name1
,
plan-name2
,...) )
Image Copy Frequency Report Parameters
Use the following parameters to specify how to generate an Image Copy Frequency Report:
UPDATES(update-threshold) ,INCLUDE|EXCLUDE( ,TSNAME(
tablespace1
,
tablespace2
,...) )
Rollback Activity Report Parameters
Use the following parameters to specify how to generate a Rollback Activity Report:
LEVEL(SUMMARY|DETAIL) ,ORDERBY(AUTHID|PLAN|URID) ,INCLUDE|EXCLUDE(AND|OR ,PLAN(
plan-name1
,
plan-name2
,...) ,AUTHID(
authid1
,
authid2
,...) )
Recovery Point Analysis Report Parameters
Use the following parameters to specify how to generate a Recovery Point Analysis Report:
LOGPOINT (ALL|RANGE) ,REGISTER (YES|NO) ,INCLUDE ( ,TSNAME(
tablespace1
,
tablespace2
) )
DDL Activity Report Parameters
Use the following parameters to specify how to generate a DDL Activity Report:
LEVEL(SUMMARY|DETAIL|TOTAL|OBJECT) ,GRANTREV (INCLUDE|EXCLUDE) ,BINDRBND (INCLUDE|EXCLUDE) ,LOBDATA (INCLUDE|EXCLUDE) ,FORM (
creator
,
form-name
) ,OPTS (
YES
|NO) ,INCLUDE|EXCLUDE(AND|OR ,PLAN (
plan-name1
,
plan-name2
,...) ,AUTHID(
authid1
,
authid2
,...) ,CORRID(
correlation-id1
,
correlation-id2
,...) ,CONNID(
connection-id1
,
connection-id2
,...) ,URID(
urid1
,
urid2
,
urid3
,...) ) ,OBJFILT (INCLUDE ( DBNAME(
database1
,
database2
,...) ,TSNAME(
tablespace1
,
tablespace2
,...) ) ) [,GENDDL (UNDO|REDO ,GENOBIDS (YES|NO) ,URHEAD (YES|NO) ,SQLID (
sqlid
) )]
Restrictions:
  • GENDDL
    is valid only with
    LEVEL(DETAIL)
    .
Change Data Capture Analysis Report Parameters
Use the following parameters to specify how to generate a Change Data Capture Analysis Report:
LEVEL(SUMMARY|DETAIL) ,ROWCOMP (NO|IMAGCOPY) ,ROLLBACK (INCLUDE|EXCLUDE|ONLY) ,CATALOG (INCLUDE|EXCLUDE) ,UNDEFTB (INCLUDE|EXCLUDE) ,INCLUDE|EXCLUDE (AND|OR ,TABLE (
table1
,
table2
,...) ,DBNAME (
database1
,
database2
,...) ,PLAN (
plan1
,
plan2
,...) ,AUTHID(
authid1
,
authid2
,...) ,CORRID(
correlation-id1
,
correlation-id2
,...) ,CONNID(
connection-id1
,
connection-id2
,...) ,URID (
urid1
,
urid2
,...) )
Quiet Point Analysis Report Parameters
Use the following parameters to specify how to generate a Quiet Point Analysis Report:
TSLIST(
dbname1
.
tsname1
,
dbname2
.
tsname2
,...)|OLMLIST(
creator.name
) ,THRESHLD (
int
) ,LOGLABEL (
creator.name
) ,QPTYPE (NONE|BIGGEST|MIDDLE|HIGHEST|LOWEST) ,REGISTER (YES|NO) ,FORMAT (REPORT|XML) ,OPTS (YES|NO)
Batch Processor Data Set Release Allocation Commands
The following commands release the data sets that are allocated to execute
Log Analyzer
:
.FREEFI(LADXTRCT)... .FREEFI(LADXCNTL)... .FREEFI(LADREPT)... .FREEFI(LADLOAD)... .FREEFI(LADSQL)... .FREEFI(LADDISC)...
For a complete list of the allocation options, see the
Database Management Solutions for Db2
documentation.