I need to connect to DB2 through Unix and check whether the database is up or not. We are planning to use Neon shadow direct to connect to the same. I would like to know how to pass parameters to neon shadow direct. Any guidance/help in this regard would be helpful.
My unix box is AIX 1.
... (3 Replies)
Hi i am working on a script which takes a parameter file as input . this parameter file is having SQL statements. I am fetching column names from the output of SQL file using following code:
while read Record1
do
SQLQuery=`echo $Record1 | awk '{printf $0 }'`
... (2 Replies)
I am trying to install a DB2 90-day trail but I got the error with the DISPLAY, it says is not configured correctly. I cannot post the error due to I am not in my personal PC but when I type: echo $DISPLAY it shows nothing.
I also tried: xclock & and nothing appears just an error. I know there... (2 Replies)
Hi,
When i try to connect to the db2 database from unix solaris 5.8 version by typing "db2" from the .../sqllib/bin/ folder, i am not getting the db2 command prompt. Could anyone help me resolve this? Here the db2 is executable only. But still iam not getting the db2 prompt.
The error i get is... (4 Replies)
I need to pass a variable as a parameter from shell script into a DB2 database.
var=bhuk_1123_Q_11/22/09
select * from tbl1 where serial_id='$var';
I have tried executing it using
db2 -tvf scriptname
Somebody please help me out with this. It is throwing an error. Please tell me how... (2 Replies)
Hi All,
I have browsed through the forums for a similar topic, but there is no topic which explains about this problem, when the backend is DB2.
I want to assign the output of a select count(*) from tablename to a unix variable in a shell script.
I am using ksh.
The database used to... (3 Replies)
Hi All,
Please help me out in executing the following db2 querry in unix
db2 "select AP_RQ_ACQ_INST_ID || ',' || txn_classifier || ',' || AP_RS_RESP_CD || ',' || (count(*) AS COUNT1) || ',' || (SUM(AP_RQ_TXN_AMT) AS TOTAL_AMT) from TXN_RECORD where
CREATE_TS > '2010-11-22 11:00:00.008645' ... (1 Reply)
I am currently trying to load data from e.txt into tablea. I am getting error.
db2 connect to qw01p user wcs using abc
db2 "LOAD CLIENT FROM /dswork/ECONT/output/interface/e.txt OF DEL MODIFIED BY coldel| SAVECOUNT 0 ROWCOUNT 0 WARNINGCOUNT 0 MESSAGES XTMPRTI1.txt
REPLACE into WCSADM.TABLEA... (1 Reply)
I am new to Putty, Unix and DB2 and this is what I am working on right now.
I installed Putty
I got access to username / pwd
I got Unix usrname/Pwd.also got the home directory
once I login into putty I get the screen and it shows $ sign
From here how do I connect to DB2 database?
I have... (2 Replies)
I have a shell script main.ksh We are calling dbscript.ksh from main.ksh
I am using select statement in dbscript.ksh but there is a problem with the select statement in dbscript.ksh but still echo $? is showing as zero. I am using DB2 commands in dbscript.ksh
Main.ksh
dbscript.ksh
echo $? ... (13 Replies)
Discussion started by: vamsi.valiveti
13 Replies
LEARN ABOUT REDHAT
pvm_barrier
BARRIER(3PVM) PVM Version 3.4 BARRIER(3PVM)NAME
pvm_barrier - Blocks the calling process until all processes in a group have called it.
SYNOPSIS
C int info = pvm_barrier( char *group, int count )
Fortran call pvmfbarrier( group, count, info )
PARAMETERS
group Character string group name. The group must exist and the calling process must be a member of the group.
count Integer specifying the number of group members that must call pvm_barrier before they are all released. Though not required, count
is expected to be the total number of members of the specified group.
info Integer status code returned by the routine. Values less than zero indicate an error.
DESCRIPTION
The routine pvm_barrier blocks the calling process until count members of the group have called pvm_barrier. The count argument is
required because processes could be joining the given group after other processes have called pvm_barrier. Thus PVM doesn't know how many
group members to wait for at any given instant. Although count can be set less, it is typically the total number of members of the group.
So the logical function of the pvm_barrier call is to provide a group synchronization. During any given barrier call all participating
group members must call barrier with the same count value. Once a given barrier has been successfully passed, pvm_barrier can be called
again by the same group using the same group name.
If pvm_barrier is successful, info will be 0. If some error occurs then info will be < 0.
EXAMPLES
C:
inum = pvm_joingroup( "worker" );
.
.
info = pvm_barrier( "worker", 5 );
Fortran:
CALL PVMFJOINGROUP( "shakers", INUM )
COUNT = 10
CALL PVMFBARRIER( "shakers", COUNT, INFO )
ERRORS
These error conditions can be returned by pvm_barrier
PvmSysErr
pvmd was not started or has crashed.
PvmBadParam
giving a count < 1.
PvmNoGroup
giving a non-existent group name.
PvmNotInGroup
calling process is not in specified group.
SEE ALSO pvm_joingroup(3PVM)
30 August, 1993 BARRIER(3PVM)