Analysing truss log Post: 302093570

Sponsored Content

Top Forums UNIX for Advanced & Expert Users Analysing truss log Post 302093570 by buytamil on Friday 20th of October 2006 11:55:17 AM

10-20-2006

Registered User

Analysing truss log

I am facing the following issue when using db2. The JDBC prepared statement command is sending an incorrect value to the database for search. I did a truss on the app and here is the log. I want to know what is the value that is getting passed. is it possible.

26867/68: send(62, 0x02354050, 310, 0) = 310
26867/68: \0 ND0 Q\001\0 H \r\0 D !13C4C2F2C4 @ @ @ @ @ @ @ @ @ @ @ @ @ @
26867/68: D5E4D3D3C9C4 @ @ @ @ @ @ @ @ @ @ @ @E2E8E2E2C8F2F0F0 @ @ @ @ @ @
26867/68: @ @ @ @ S Y S L V L 0 1\006\018D0 S\001\012 $ P\0\n W I T H H
26867/68: O L D \0\0\0D0D003\001\0CA $14\0C2 S E L E C T I D _ A P P L
.
.
. I removed the SQL Query
.
.
26867/68: _ S Y S T F O R F E T C H O N L Y\0\0
26867/10: poll(0xF997FD18, 0, 50) = 0
26867/68: recv(62, 0x0234C040, 32767, 0) = 86
26867/68: \0 VD003\001\0 P $\b\0\0\0\0\0 0 0 0 0 0 D S N \0 E T S
26867/68: D B 2 D \0\0\0\0\0\0\0\0\0\0\0\0 A &88FE\0
26867/68: \0\0\0\0\0\0\0 \0\0\0\0
26867/68: send(62, 0x02354050, 144, 0) = 144
26867/68: \0 \D0 Q\001\0 V \f\0 D !13C4C2F2C4 @ @ @ @ @ @ @ @ @ @ @ @ @ @
26867/68: D5E4D3D3C9C4 @ @ @ @ @ @ @ @ @ @ @ @E2E8E2E2C8F2F0F0 @ @ @ @ @ @
26867/68: @ @ @ @ S Y S L V L 0 1\006\0\b !14\0\07FFF\006 ! AFFFF\0 4D003
26867/68: \001\0 . $12\013\010\t vD005\002 ?7FFF06 qE4D0\001\01714 z\0\002
26867/68: \t\0\0\f T T _ P L U M I C I N G
26867/68: recv(62, 0x0234C040, 32767, 0) = 200
26867/68: \0 D0 R\001\01A "05\00611 I\0\0\006 !02 $17\005 !1FF1\005 ! P01
26867/68: \013D0 S\001\0\r\0 /D8E3C4E2D8D3F3F7F0\01CD0 S\001\016\0 5\00611
26867/68: 9C01F4\006119D\0\0\006119E01F4\0 "D0 S\001\01C $1A\t vD0 3\0\n 3
26867/68: \014\t qE0 T\001D0\00106 qF0E0\0\0\0 WD003\001\0 Q $1B\0\0\0\0 d
26867/68: F0F2F0F0F0C4E2D5E7D9C6D5 @\0C5E3E2C4C2F2C4 @ @ @ @ @ @ @ @ @ @ @
26867/68: FFFFFF92\0\0\0\0\0\0\0\0FFFFFFFF\0\0\0\0\0\0\0\0 @ @ @ @ @ @ @ @
26867/68: @ @ @\0\0\0\0FF
26867/68: write(46, 0xC857BF40, 965) = 965
26867/68: 1 0 / 2 0 / 2 0 0 6 1 1 : 0 2 : 3 9 : 8 1 2 2 [ E x e c u
26867/68: t e T h r e a d : ' 5 6 ' f o r q u e u e : ' d e f a u

buytamil

View Public Profile for buytamil

Find all posts by buytamil

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Help analysing progress of a log file

Is it possible to track the progress of a job (informatica) by analysing the progress of it's log file ? I have a long running job, and no way of tracking how far allong it is. Thanks.

2. HP-UX

Query: Analysing the Core file

Hi, Is there any way to find the mode of the binary file (debug or release) by analyzing the core file generated by that binary on the HPUX11i Platform?

3. Shell Programming and Scripting

how to use truss?

Hi all, while trying to debug and figure out why a lofiadm command was not working on my script, i came across a cmd called "truss" all i know about it is that it executes the specified command and produces a trace of the system calls it performs, the signals it receives, and the machine faults...

4. UNIX for Dummies Questions & Answers

Analysing Log Files?

I'm not sure if this query is relevant to this forum but here goes anyways... I want analyse log files that do not appear to be of standard format. I have tried using Analog but cannot config it to read the files. Does anyone have any advice on working with log files taken from a Unix...

5. Shell Programming and Scripting

need help with truss !

i have to gather some info about a process and redirect it to a1.txt file. For this i m using truss command truss -po a1.txt $PID_Detail where $PID_Detail= 1482944 3362976 -------------------------------------------------------------------------- Below the script: #!/bin/ksh for i...

6. Solaris

Analysing a core dump.

Friends I was trying to analyse a core dump using pstack command in Sol5.9(Sparc) The output is as below. root: pstack core_mumux211_istauth_220_108_1229517198_21922 core 'core_mumux211_istauth_220_108_1229517198_21922' of 21922: istauth fe1afbb8 ttcdrv (c10e0, c1db4, 30ad8, bc950, 0, 0)...

7. Shell Programming and Scripting

Analysing Mail Logs

Hello, I have a list of e-mails. I need to know, which email-s from that list not use. I want to do this things: - take email address from email list - find this address in mail logs - if, there is no record about this e-mail adress in list, show this e-mail address on screen I did...

8. Shell Programming and Scripting

Reading and analysing data in a text file

Hi, I have below type of data in a text file in unix. Emp_Name Emp_Dept Raj 101 Amruta 100 Shilpa 100 Rohit 123 Amol 198 Rosh 101 Gaurav 198 Number of employees can be even more. Need a command or a...

9. AIX

Issue with nmon analysing

Dear Experts, Am using nmon analyser version 3.3g, and when i tried analyzing my current nmon file it was done successfully. But the problem is all my old nmon files are compressed. So i uncompressed and analyzed using the same analyzer. but got this error no valid input data! nmon run may...

10. Shell Programming and Scripting

Problems in analysing SSH LOG users & time

Attached is the log file that I have generated through the following script: last | head -2 |sed '2q;d' |awk '{ print $1"\t"$2"\t"$3"\t\t"$4"\t"$5"\t"$6"\t"$7"\t"$8"\t" $9"\t"$10"\t"$11}'>>/var/log/logadmin/logtest.txt But now I'm unable to run the following operations on it: 1. Count...

LEARN ABOUT OSX

execute

EXECUTE(7)                                                         SQL Commands                                                         EXECUTE(7)

NAME

       EXECUTE - execute a prepared statement

SYNOPSIS

       EXECUTE name [ ( parameter [, ...] ) ]

DESCRIPTION

       EXECUTE  is  used  to execute a previously prepared statement. Since prepared statements only exist for the duration of a session, the pre-
       pared statement must have been created by a PREPARE statement executed earlier in the current session.

       If the PREPARE statement that created the statement specified some parameters, a compatible set of parameters must be passed to the EXECUTE
       statement,  or  else an error is raised. Note that (unlike functions) prepared statements are not overloaded based on the type or number of
       their parameters; the name of a prepared statement must be unique within a database session.

       For more information on the creation and usage of prepared statements, see PREPARE [prepare(7)].

PARAMETERS

       name   The name of the prepared statement to execute.

       parameter
              The actual value of a parameter to the prepared statement. This must be an expression yielding a value that is compatible  with  the
              data type of this parameter, as was determined when the prepared statement was created.

OUTPUTS

       The command tag returned by EXECUTE is that of the prepared statement, and not EXECUTE.

EXAMPLES

       Examples are given in the Examples [prepare(7)] section of the PREPARE [prepare(7)] documentation.

COMPATIBILITY

       The  SQL  standard includes an EXECUTE statement, but it is only for use in embedded SQL. This version of the EXECUTE statement also uses a
       somewhat different syntax.

SEE ALSO

       DEALLOCATE [deallocate(7)], PREPARE [prepare(7)]

SQL - Language Statements                                           2010-05-14                                                          EXECUTE(7)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Help analysing progress of a log file

Discussion started by: cosmos328is

2. HP-UX

Query: Analysing the Core file

Discussion started by: Prajakta

3. Shell Programming and Scripting

how to use truss?

Discussion started by: wrapster

4. UNIX for Dummies Questions & Answers

Analysing Log Files?

Discussion started by: Sepia