To start COB Go to DBTools in JQL mode and execute the below command.
Go to execute servlet and start TSM
To start COB in single agent, set AGENTS.REQUIRED to one in TSA.WORKLOAD.PROFILE and then start TSM in servlet.
To clear a file: In TAFC we use the command ‘CLEAR.F ILE F.EB.EOD.ERROR’, for TAFJ syntax as below Syntax: DBTools –s JQL CLEAR-FILE <> Sample: DBTools –s JQL CLEAR-FILE F.EB.EOD.ERROR
To View a record: Go to DBTools & enter in to JQL mode, use the command LIST-ITEM to view the records Below command is used to view record in JQL mode. Syntax1: >DBTools JQL LIST-ITEM <> <> Sample1: >DBTools JQL LIST-ITEM F.LOCKING F.BUILD.CONTROL
Syntax2:>DBTools JQL LIST-ITEM F.LOCKING LIKE …<>… Sample2:> DBTools JQL LIST-ITEM F.LOCKING LIKE ...BNK/AA.SOD.PROCESS... To view records in JOB.LIST Sample: >DBTools JQL LIST-ITEM F.JOB.LIST.2
To View LOCKS: In TAFC we will be using SHOW-ITEM-LOCKS, for TAFJ get .Properties file and check the below key in order to identify the type of LOCK.
If the locking mode was set as JDBC, Syntax: > DBTools –s JQL LOCKS
Query used by DBTools for Oracle locking , i.e., if the mode was set as ORCL Syntax: > SELECT ID1, SID FROM v$lock WHERE type = 'UL'
If log4j.appender.locking.File in Trace.properties is set as /locking.log then obtaining the file locking.log will give us details about locking.
TAFJ Session Monitor: It is similar to Mw42 in TAFC. TAFJ Session Monitor is a tool to monitor T24 session activities like no. of method calls, read and write etc. URL syntax: <>:<>/ SessionMonitor/ Sample: localhost:8370/SessionMonitor/ 10.233.89.11:8370/SessionMonitor/
Note: jboss should be running for this one
To modify a record using JED command We can use JED to modify record, Syntax: >tJED <> <> Sample: >tJED F.BATCH BNK/AC.SYS.END.OF.DAY
Use ‘f’ to move down/forward and b to move up/backward. To modify third field from 0 to 2, type ‘3’ and press enter.
Cursor will be pointing to the line which you want to modify, enter the value you want to replace and press ENTER.
File will be modified as below with status as “PENDING”
Enter s to save the record, then status will be changed to SAVED.
To COUNT no. of records Syntax: >DBTOOLS JQL COUNT <>
To CREATE a table Syntax: >DBTools JQL CREATE-FILE <> Sample: >DBTools JQL CREATE-FILE FBNK.ACC
To check the file name and DICT created, use GETDBNAME command Syntax: >DBTOOLS JQL GETDBNAME <>
To Create a UD file Syntax: >DBTools JQL CREATE-FILE <> TYPE=UD
To check the file name and DICT created, use GETDBNAME command Syntax: >DBTOOLS JQL GETDBNAME <>
To COPY a File or Records To COPY records from one table to another table Syntax: COPY <> <> <>
To COPY records from table to UD file, in this COUNT command will not show any output but physical records which are copied will be available in the destination FBNK.STMT_BACKUP.
To restore the backup or to COPY the records from UD file to Table, execute the below program. PROGRAM TESTPRG EXE.CMD="COPY FROM LOCKING TO F.LOCKING ALL" EXECUTE EXE.CMD RETURN
JSTAT This output will be helpful to check oracle filename, creation date and record count. Syntax: >DBTools JQL STATS <>
