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)
I am trying to connect to database db2 through shell script.
The process I am trying is
> db2
It gives me error Access Denied.
While checking for access I have the rights.
Is there ant other way round..?
Please help. (3 Replies)
Hi All,
I want to connect two tables in DB2 using shell script and then compare the contents of two tables field by field. Could any one please help me in connecting database tables using Unix and retriving data from the same.
Thanks,
Durwas (0 Replies)
Hello friends,
Assume that, I am trying to execute a "db2 connect" command from Linux shell prompt via a shell script called "sample"
sample
db2 connect to bas39
$sample
If the database is not present its should display a custom error message by catching the error message given by db2.... (1 Reply)
Can anyone please help me with an unix shell script to connect a DB2 database. My requirement is just to display the no of records present in a table of a DB2 database through Unix Shell script. Thx - Ram (1 Reply)
I am rather new to korn shell scripting and attempting to write a Unix script that would detach, attach a range partition table in DB2 UDB LUW database. This would be a job scheduled in control M that reads in an input file with 5 parameters passed to it from the application. I don't have much... (1 Reply)
Hi
I am trying to connect to db2 database from Unix shell script (k shell)
I need to catch the status of connect whether it is succesful or not.
----------------------------------------------------------
# Read login credentials for db2
tput clear
echo "Please enter your Userid:\c"... (3 Replies)
Guys,
I am trying to write a shell script that connect to wcsprod database and read the query
#!/bin/ksh
sqlplus -s < connect to wcsprod user wcsadm using pwd >
select * from catentry fetch first 1 row only with ur;
databse: wcsprod
user: wcsadm
pwd: pwd
thanks (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)
Discussion started by: JayDoshi
2 Replies
LEARN ABOUT CENTOS
papi_remove_event
PAPI_remove_event(3) PAPI PAPI_remove_event(3)NAME
PAPI_remove_event -
removes a hardware event from a PAPI event set.
SYNOPSIS Detailed Description
A hardware event can be either a PAPI Preset or a native hardware
event code. For a list of PAPI preset events, see PAPI_presets or
run the papi_avail utility in the PAPI distribution. PAPI Presets
can be passed to PAPI_query_event to see if they exist on the
underlying architecture. For a list of native events available on
the current platform, run papi_native_avail in the PAPI distribution.
@par C Interface:
int PAPI_remove_event( int EventSet, int EventCode );
@param[in] EventSet
-- an integer handle for a PAPI event set as created
by PAPI_create_eventset
@param[in] EventCode
-- a defined event such as PAPI_TOT_INS or a native event.
@retval PAPI_OK
Everything worked.
@retval PAPI_EINVAL
One or more of the arguments is invalid.
@retval PAPI_ENOEVST
The EventSet specified does not exist.
@retval PAPI_EISRUN
The EventSet is currently counting events.
@retval PAPI_ECNFLCT
The underlying counter hardware can not count this
event and other events in the EventSet simultaneously.
@retval PAPI_ENOEVNT
The PAPI preset is not available on the underlying hardware.
@par Example:
* int EventSet = PAPI_NULL;
* int ret;
*
* // Create an empty EventSet
* ret = PAPI_create_eventset(&EventSet);
* if (ret != PAPI_OK) handle_error(ret);
*
* // Add Total Instructions Executed to our EventSet
* ret = PAPI_add_event(EventSet, PAPI_TOT_INS);
* if (ret != PAPI_OK) handle_error(ret);
*
* // Start counting
* ret = PAPI_start(EventSet);
* if (ret != PAPI_OK) handle_error(ret);
*
* // Stop counting, ignore values
* ret = PAPI_stop(EventSet, NULL);
* if (ret != PAPI_OK) handle_error(ret);
*
* // Remove event
* ret = PAPI_remove_event(EventSet, PAPI_TOT_INS);
* if (ret != PAPI_OK) handle_error(ret);
*
See Also:
PAPI_cleanup_eventset
PAPI_destroy_eventset
PAPI_event_name_to_code
PAPI_presets
PAPI_add_event
PAPI_add_events
Author
Generated automatically by Doxygen for PAPI from the source code.
Version 5.2.0.0 Tue Jun 17 2014 PAPI_remove_event(3)