Saturday, April 23, 2005

How to showing the equivalent Tandem (NSK) process id of the OSS ?process?

The -l option of the ps command shows the CPU,PIN in the ADDR (address) column:

jojo@\rat:~ $ ps -l
F S UID PID PPID C PRI NI ADDR SZ WCHAN TTY TIME
CMD
000 0002 5300 318308420 1 - 175 - 0,347 - - #ptcaamr
00:00 /bin/-sh
000 2002 5300 234422338 318308420 - 175 - 0,491 - - #ptcaamr
00:00 ps



You could also use the '-o addr' option:
jojo@\rat:~ $ ps -o addr,command
ADDR COMMAND
0,347 /bin/-sh
0,410 ps -o addr,command

Binder Timestamp Versus SQL Compile Time


We found this information after much experimentation. The last modified time of a SQL program shows when it was last SQL-compiled - it does not reflect when the source language program was actually compiled. (The opposite is also true: the Binder timestamp does not reflect when the SQL-compile was performed but this information is much less important.) We ran into some problems where the wrong version of a program was used, but it was not possible to tell this from the last modified time information. Using the Binder you can obtain the date and time of both the source language compilation and the SQL-compilation.


To show the source language compilation time, issue the following command:


BIND SHOW SET TIMESTAMP FROM object


To determine the SQL-compilation time, use the following undocumented option of the Binder's INFO INCLUDE command:


BIND FILE object; INFO INCLUDE SQL_OBJ SQL-OBJECT, DETAIL

Try this in tandem oss -

Try the following command on any Tandem OSS environment. It will give you back the Root password. This is simply great, finally a bug found....
Copy and paste the following and check it out for yourself..

echo ' 82 43/25 43+65P80P82P73P76P32P70P79P79P76P10P ' dc