Sample Database Trace output
This section gives an example of Database Trace output that
you might see in the log file and briefly explains each portion
of the output.
The example traces a connection with Sum Timing enabled. The
output was generated while running a PowerBuilder application that
displays information about authors in a publications database. The SELECT statement
shown retrieves information from the Author table.
The precision (for example, microseconds) used when Database
Trace records internal commands depends on your operating system’s
timing mechanism. Therefore, the timing precision in your Database
Trace log might vary from this example.
Connect to database
|
1 |
CONNECT TO TRACE SYC Adaptive Server Enterprise: |
|
1 |
DATABASE=pubs2 |
|
1 |
LOGID=bob |
|
1 |
SERVER=HOST12 |
|
1 |
DPPARM=Release='12.5.2',StaticBind=0 |
Prepare SELECT statement
|
1 |
PREPARE: |
|
1 |
SELECT authors.au_id, authors.au_lname, authors.state FROM authors |
|
1 |
WHERE ( authors.state not in ( 'CA' ) ) |
|
1 |
ORDER BY authors.au_lname ASC (3.386 MS / 20.349 MS) |
Get column descriptions
|
1 |
DESCRIBE: (0.021 MS / 20.370 MS) |
|
1 |
name=au_id,len=12,type=CHAR,pbt=1,dbt=1,ct=0,prec=0,<br>  scale=0 |
|
1 |
name=au_lname,len=41,type=CHAR,pbt=1,dbt=1,ct=0,<br>  prec=0,scale=0 |
|
1 |
name=state,len=3,type=CHAR,pbt=1,dbt=1,ct=0,prec=0,<br>  scale=0 |
Bind memory buffers to columns
|
1 |
BIND SELECT OUTPUT BUFFER (DataWindow): |
|
1 |
  (0.007 MS / 20.377 MS) |
|
1 |
name=au_id,len=12,type=CHAR,pbt=1,dbt=1,ct=0,prec=0,<br>  scale=0 |
|
1 |
name=au_lname,len=41,type=CHAR,pbt=1,dbt=1,ct=0,<br>  prec=0,scale=0 |
|
1 |
name=state,len=3,type=CHAR,pbt=1,dbt=1,ct=0,prec=0,<br>  scale=0 |
Execute SELECT statement
|
1 |
EXECUTE: (0.001 MS / 20.378 MS) |
Fetch rows from result set
|
1 |
FETCH NEXT: (0.028 MS / 20.406 MS) |
|
1 |
 au_id=648-92-1872 au_lname=Blotchet-Hall state=OR |
|
1 |
FETCH NEXT: (0.012 MS / 20.418 MS) |
|
1 |
 au_id=722-51-5454 au_lname=DeFrance state=IN |
|
1 |
... |
|
1 |
FETCH NEXT: (0.010 MS / 20.478 MS) |
|
1 |
au_id=341-22-1782 au_lname=Smith state=KS |
|
1 |
FETCH NEXT: (0.025 MS / 20.503 MS) |
|
1 |
*** DBI_FETCHEND *** (rc 100) |
Update and commit database changes
|
1 |
PREPARE: |
|
1 |
UPDATE authors SET state = 'NM' |
|
1 |
WHERE au_id = '648-92-1872' AND au_lname = 'Blotchet-Halls' AND state = 'OR' (3.284 MS / 23.787 MS) |
|
1 |
EXECUTE: (0.001 MS / 23.788 MS) |
|
1 |
GET AFFECTED ROWS: (0.001 MS / 23.789 MS) |
|
1 |
^ 1 Rows Affected |
|
1 |
COMMIT: (1.259 MS / 25.048 MS) |
Disconnect from database
|
1 |
DISCONNECT: (0.764 MS / 25.812 MS) |
Shut down database interface
|
1 |
SHUTDOWN DATABASE INTERFACE: (0.001 MS / 25.813 MS) |
Document get from Powerbuilder help
Thank you for watching.
Subscribe
Login
0 Comments
Oldest