DB2 Server for VSE & VM: Database Services Utility

Working with a Message File

The Database Services Utility automatically creates a message file with the name you supplied in the SQLDBSU EXEC parameter. If a file already exists with the same name, it is overwritten.

After the utility is run and finishes its processing, view the message file to see the results of processing the control file commands. Figure 8 shows the contents of message file COMMANDS RESULT A.

Figure 8. Database Services Utility: Sample Message File Output

1ARI0801I DBS Utility started: 07/18/89 16:10:31. <------------(1) AUTOCOMMIT = OFF ERRORMODE = OFF <----*----(2) ISOLATION LEVEL = REPEATABLE READ <----* 0------> SELECT * FROM SQLDBA.DEPARTMENT; <------------(3) 1SELECT * FROM SQLDBA.DEPARTMENT PAGE 1 0DEPTNO DEPTNAME MGRNO ADMRDEPT ---* ------ ----------------------------- ------ -------- | A00 SPIFFY COMPUTER SERVICE DIV. 000010 A00 | B01 PLANNING 000020 A00 | C01 INFORMATION CENTER 000030 A00 | D01 DEVELOPMENT CENTER A00 *-----(4) D11 MANUFACTURING SYSTEMS 000060 D01 | D21 ADMINISTRATION SYSTEMS 000070 D01 | E01 SUPPORT SERVICES 000050 A00 | E11 OPERATIONS 000090 E01 | E21 SOFTWARE SUPPORT 000100 E01 | 0ARI0850I SQL SELECT processing successful: Rowcount = 9 ---* 1------> SELECT * FROM SQLDBA.PROJECT; <------------(5) 1SELECT * FROM SQLDBA.PROJECT PAGE 2 0PROJNO PROJNAME DEPTNO RESPEMP PRSTAFF PRSTDATE PRENDATE --* ------ ------------------- ------ ------- ------- ---------- ---------- | AD3100 ADMIN SERVICES A00 000010 6.50 1982-01-01 1983-02-01 | MA2100 WELD LINE AUTOMATIO D01 000010 12.00 1982-01-01 1983-02-01 | AD3111 PAYROLL PROGRAMMING B01 000020 2.00 1982-01-01 1983-02-01 | PL2100 WELD LINE PLANNING B01 000020 1.00 1982-01-01 1982-09-15 | IF1000 QUERY SERVICES C01 000030 2.00 1982-01-01 1983-02-01 | IF2000 USER EDUCATION C01 000030 1.00 1982-01-01 1983-02-01 | OP1000 OPERATION SUPPORT E01 000050 6.00 1982-01-01 1983-02-01 | OP2000 GEN SYSTEMS SERVICE E01 000050 5.00 1982-01-01 1983-02-01 | MA2110 W L PROGRAMMING D11 000060 9.00 1982-01-01 1983-02-01 | AD3110 GENERAL AD SYSTEMS E11 000090 6.00 1982-01-01 1983-02-01 | OP1010 OPERATION E11 000090 5.00 1982-01-01 1983-02-01 *--(6) OP2010 SYSTEMS SUPPORT E21 000100 4.00 1982-01-01 1983-02-01 | MA2112 W L ROBOT DESIGN D11 000150 3.00 1982-01-01 1982-12-01 | MA2113 W L PROD CONT PROGS D11 000160 3.00 1982-02-15 1982-12-01 | MA2111 W L PROGRAM DESIGN D11 000220 2.00 1982-01-01 1982-12-01 | AD3112 PERSONNEL PROGRAMMG D21 000250 1.00 1982-01-01 1983-02-01 | AD3113 ACCOUNT.PROGRAMMING D21 000270 2.00 1982-01-01 1983-02-01 | OP2011 SCP SYSTEMS SUPPORT E21 000320 1.00 1982-01-01 1983-02-01 | OP2012 APPLICATIONS SUPPOR E21 000330 1.00 1982-01-01 1983-02-01 | OP2013 DB/DC SUPPORT E21 000340 1.00 1982-01-01 1983-02-01 | 0ARI0850I SQL SELECT processing successful: Rowcount = 20 --* 1ARI0802I End of command file input. <------------(7) ARI8997I ...Begin COMMIT processing. ------* ARI0811I ...COMMIT of any database changes successful. | ARI0809I ...No error(s) occurred during command processing. *------(8) ARI0808I DBS processing completed: 07/18/89 16:10:33. ------*

Notes for Figure 8:  

(1)

The Database Services Utility start message.

(2)

The Database Services Utility default values. See Set-Item Commands in Chapter 8, Command Reference for details on changing these defaults.

(3)

The first SELECT statement that the Database Services Utility processes.

(4)

Results of the Database Services Utility processing the SELECT statement show the rows retrieved from the table, a message indicating that the SELECT statement was successful, and the number of rows retrieved.

(5)

The next SELECT statement that the Database Services Utility processes.

(6)

Results of the Database Services Utility processing the SELECT statement show the rows retrieved from the table, a message indicating that the SELECT statement was successful, and the number of rows retrieved.

(7)

Database Services Utility has processed all commands in the control file.

(8)

Database Services Utility completion messages.