db2 CLP and PS output on AIX

Erik Hendrix

Hi,

When I run a DB2 command:
i.e.: db2 list tablespaces show detail

and while this is running do: ps -ef | grep "db2 "

then I can see in the output the db2 command as: db2 list tablespaces show
detail

however, when I then rerun the command I see in the PS output: db2
and not the "list tablespaces show detail".

If I do a db2 terminate and then try again I see the full command again.

Does anyone know why this is and how to fix this so that I can see the full
DB2 command each and every time without having to issue a db2 terminate
first?

Thanks

Nov 12 '05 #1

Subscribe Reply

4167

cmc

I am no expert on DB2 - just a guess:
I think this is related to the db2 CLP contains two processes. The front
end process db2.exe (aka the CLP) and the backend process db2bp.exe (which
actually execute the command on behalf of the user and return to the user).
When the first time your start the command, DB server will start a backend
processs to handle all your commands - this will take a little bit time for
the startup and therefore you have time to "grep" your front end process
which contain the whole command.

After the first CLP command, the back end process will stay for the same
user (backend process know by the parent PID who send the command and
therefore know your process ID next time you send in another command). I
guess the CLP simply send the command to it's own backend process (of course
it knows there is a backend process already there) and wait for the result
with the CLP in wait mode.

When you use the TERMINATE command, CLP will tell the backend process to
shut down and the user session quit the connection.

So you start the whole thing all over again.
------
Just a two cent guess.

"Erik Hendrix" <he**********@h otmail.com> wrote in message
news:1113870666 .1f1b4ecf01f4c4 8a89ff5b871a322 907@teranews...

Hi,

When I run a DB2 command:
i.e.: db2 list tablespaces show detail

and while this is running do: ps -ef | grep "db2 "

then I can see in the output the db2 command as: db2 list tablespaces show
detail

however, when I then rerun the command I see in the PS output: db2
and not the "list tablespaces show detail".

If I do a db2 terminate and then try again I see the full command again.

Does anyone know why this is and how to fix this so that I can see the full DB2 command each and every time without having to issue a db2 terminate
first?

Thanks

Nov 12 '05 #2

Erik Hendrix

I would go with this if not for the following:

1) We can see it every time on Solaris.
2) Although the back end process indeed exists, the front-end process also
still exists. It is the fron-end proces s which thus would normally show the
command.

Thanks.

"cmc" <cm*****@yahoo. com> wrote in message
news:WE******** **********@news 20.bellglobal.c om...

I am no expert on DB2 - just a guess:
I think this is related to the db2 CLP contains two processes. The front
end process db2.exe (aka the CLP) and the backend process db2bp.exe (which
actually execute the command on behalf of the user and return to the user). When the first time your start the command, DB server will start a backend
processs to handle all your commands - this will take a little bit time for the startup and therefore you have time to "grep" your front end process
which contain the whole command.

After the first CLP command, the back end process will stay for the same
user (backend process know by the parent PID who send the command and
therefore know your process ID next time you send in another command). I
guess the CLP simply send the command to it's own backend process (of course it knows there is a backend process already there) and wait for the result
with the CLP in wait mode.

When you use the TERMINATE command, CLP will tell the backend process to
shut down and the user session quit the connection.

So you start the whole thing all over again.
------
Just a two cent guess.

"Erik Hendrix" <he**********@h otmail.com> wrote in message
news:1113870666 .1f1b4ecf01f4c4 8a89ff5b871a322 907@teranews...
Hi,

When I run a DB2 command:
i.e.: db2 list tablespaces show detail

and while this is running do: ps -ef | grep "db2 "

then I can see in the output the db2 command as: db2 list tablespaces show detail

however, when I then rerun the command I see in the PS output: db2
and not the "list tablespaces show detail".

If I do a db2 terminate and then try again I see the full command again.

Does anyone know why this is and how to fix this so that I can see the

full
DB2 command each and every time without having to issue a db2 terminate
first?

Thanks

Nov 12 '05 #3

Similar topics

8134

Capturing PERL script output into PHP variable

by: Mark Wilson CPU | last post by:

This must be easy, but I'm missing something... I want to execute a Perl script, and capture ALL its output into a PHP variable. Here are my 2 files: ------------------------------------- test3.pl ------------------------------------- print "PERL Hello from Perl! (plain print)<br>\n"; print STDERR "PERL This is text sent to STDERR<br>\n"; $output="PERL Some output:<br>\n"; for ($i=0; $i<5; $i++) {

PHP

2789

string transform with different input and output

by: edgekaos | last post by:

Is method 2 valid? Method 1: wstring input = L"STRING"; wstring output = input; transform(output.begin(), output.end(), output.begin(), towupper); Method 2: wstring input = L"STRING"; wstring output;

C / C++

15076

Reading Output from Shell Command

by: Kevin Mansel via .NET 247 | last post by:

Ok, basically this is my problem. I'm building a console app tocall a dos program. So i'm using the Shell command to call theprogram, now depending on what happens, I want to read theoutput that this program returns. I'm just missing the stepshere. I know that I can set the Shell command to an integer,but this only returns a 0 to me telling me that it executed, notwhat is being returned to the console by that application. Isthere a way to...

Visual Basic .NET

2703

What is the output of this program? and why?

by: kalamantina | last post by:

#include "stdafx.h" #include <stdio.h> #define output( x ) printf( #x "\r\n" );fflush( stdout ) class CMyBase { public: CMyBase() { output( CMyBase() ); f(*this);

C / C++

2066

how to see the 'cipher' text from the output?

by: newbie | last post by:

i'm a newbie of c language. can anyone help me to implement the code so that I can get the ciphertext from the output. thanks. #ifndef _3DES_H #define _3DES_H #ifndef uint8 #define uint8 unsigned char #endif

C / C++

2800

Is the output of the preprocessor deterministic ?

by: spibou | last post by:

Is the output of the C preprocessor deterministic ? What I mean by that is , given 2 compilers which conform to the same standard, will their preprocessors produce identical output given as input the same file ? If not then how much variation is allowed ? Is it just a bit more or less white space here and there or could could there be larger differences ? If the output is not deterministic then is it possible that the output of the...

C / C++

2631

RenderBeginTag() output not XHMTL compliant

by: MatsL | last post by:

Hi, This is seriously driving me crazy, could anyone explain to me why neither of these doesn't produce XHTML compliant output (it is being called in Render() btw): output.WriteLine("<img src=\"" + vars + " />"); output.AddAttribute(HtmlTextWriterAttribute.Src, (string)vars); output.RenderBeginTag(HtmlTextWriterTag.Img);

ASP.NET

4662

Open File/Print Output File with in a loop

by: undshan | last post by:

I am writing a code that needs to open a file, create an output file, run through my function, prints the results to the output file, and closes them within a loop. Here is my code: #include <stdlib.h> #include <stdio.h> #include <math.h> #include <string.h> #include "util.h" //Main Loop

C / C++

3330

Separate output for log file and stdout

by: amit.uttam | last post by:

Hey everyone, I've recently jumped big time into python and I'm working on a software program for testing automation. I had a question about proper logging of output. What I would like is: 1. a function syslog (to log output to log file only) 2. a function stdout (to log output to stdout only) 3. a function sslog (to log output to both log and stdout)

Python

3379

C# not returning StoredProcedure Output variable

by: gabosom | last post by:

Hi! I've been breaking my head trying to get the output variables from my Stored Procedure. This is my SP code CREATE PROCEDURE GetKitchenOrderDetail( @idService int, --outPut Variables @idUser int OUTPUT,

.NET Framework

9521

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9333

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10107

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9900

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9765

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7324

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

3863

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3442

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2733

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General