Tracing sqlturbos on hosts to client processes 
Author Message
 Tracing sqlturbos on hosts to client processes
Background: We're running Online 5.00, I-Star 5.00 and 4GL/SQL 4.10 on
RS/6000's.

Question: Is there a way to trace an sqlturbo on the host to it's
server process?

--
   / __ \/ /__  ___ / /_____ ____  ____ ___  Ed Hobbs
  / /_/ / / _ \/ __/ __/ ___/ __ \/ __ `__ \ Database Administrator
 / __  / /  __/ / / /_/ /__/ /_/ / / / / / / Alert Centre, Inc.



Mon, 10 Jun 1996 01:13:10 GMT
 Tracing sqlturbos on hosts to client processes

Quote:
Ed Hobbs writes:-
> Question: Is there a way to trace an sqlturbo on the host to it's
> server process?

The sqlturbo is the server process for the client program.  Its parent
is the client process, on a unix box the PPID of the sqlturbo is the
PID of the client process if they are running on the same box.  Use ps
-fu.

The sqlturbo uses various methods - shared memory, semaphores, etc to
communicate with the tbinit process which maintains the database.
(That isn't a precise description).  You can use tbstat with all it's
various parameters to find out what a particular sqlturbo is doing
with the database.

Cheers - Jim
My opinions are my own.  They may vary with time but they remain MINE!
----------------------------------------------------------------------

Company: DHL Systems Inc             Phone:    (415) 375-5222 (Work)
Address: 700 Airport Blvd. #300                (415) 775-7762 (Home)
         Burlingame, CA 94010-1937   Fax:      (415) 375-5019
----------------------------------------------------------------------



Mon, 10 Jun 1996 08:18:02 GMT
 Tracing sqlturbos on hosts to client processes

Quote:
Jim Gordon writes:

> Ed Hobbs writes:-
> > Question: Is there a way to trace an sqlturbo on the host to it's
> > server process?

> The sqlturbo is the server process for the client program.  Its parent
> is the client process, on a unix box the PPID of the sqlturbo is the
> PID of the client process if they are running on the same box.  Use ps
> -fu.

> The sqlturbo uses various methods - shared memory, semaphores, etc to
> communicate with the tbinit process which maintains the database.
> (That isn't a precise description).  You can use tbstat with all it's
> various parameters to find out what a particular sqlturbo is doing
> with the database.

Fine if you're on the same box, but how about when it's an IStar connection?
Anyone?

cheers and merry xmas
Back 1/3/94
j.
_____________________________________________________________________________
Jack Parker                            |"Almost had a heart attack,
Hewlett Packard, BSMC Boise, Idaho, USA| Looking in my rear-view mirror,

(208) 396-5388 (W)  (208) 384-1623 (H) | Looking in my rear-view mirror,
                                       | About to have a heart attack."
                                       |               - JT
_____________________________________________________________________________
I must be getting road fever - my third car related quote in a week!
_____________________________________________________________________________
   Any opinions expressed herein are my own and not those of my employers.
_____________________________________________________________________________



Mon, 10 Jun 1996 15:48:08 GMT
 Tracing sqlturbos on hosts to client processes

Quote:
> Jim Gordon writes:
> > The sqlturbo is the server process for the client program.  Its parent
> > is the client process, on a unix box the PPID of the sqlturbo is the
> > PID of the client process if they are running on the same box.  Use ps
> > -fu.
> Fine if you're on the same box, but how about when it's an IStar connection?
> Anyone?

> cheers and merry xmas
> Jack Parker                            |"Almost had a heart attack,

The best answer I can give you is that you find out the user name that
the connection is using and check for a sqlturbo with that username
with a PPID of the sqlexecd process which is the I-Star deamon.  The
sqlexecd process should also have the correct engine name!

I'm sorry, off hand, I don't know how to distinguish multiple users
all using the same login name.  It could have something to do with the
licence number reported by the sqlturbo running on the host?  But on
mine it doesn't appear to report the license number of my I-Net
software.

Cheers - Jim
My opinions are my own.  They may vary with time but they remain MINE!
----------------------------------------------------------------------

Company: DHL Systems Inc             Phone:    (415) 375-5222 (Work)
Address: 700 Airport Blvd. #300                (415) 775-7762 (Home)
         Burlingame, CA 94010-1937   Fax:      (415) 375-5019
----------------------------------------------------------------------



Tue, 11 Jun 1996 03:23:18 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Tracing sqlturbos on hosts to client processes

2. Tracing sqlturbos back to client connection

3. Tracing a host's IP number and full host name

4. Tracing a host's IP number and full host name

5. Tracing sqlturbo processes back to client PC

6. Can Win Client open Mac Client-hosted db?

7. Trace CPU usage by host?

8. SQL Trace Host identification error

9. Processing SQL Trace output on 6.5

10. missing host process in sysproc

11. Getting the host name from a process

12. Host Name in process information


 
Powered by phpBB® Forum Software