10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a shell script and im trying to call a .sql file. The sql file has a simple Anonymous block.
The code is
shell script
db2 -tvf query.sql
the sql file contains
SET SERVEROUTPUT ON;
BEGIN
call dbms_output.put_line( 'Hello' );
END;
I get the following error
BEGIN... (1 Reply)
Discussion started by: sup
1 Replies
2. Solaris
Hi,
I have a server with Solaris 11 with a zpool raid to serve as a NAS. Every day in the morning I do an incremental snapshot of the zpool and send it to another local disk as a backup.
I would now like to build another small server to hold backups in a different place to prevent data loss... (0 Replies)
Discussion started by: RychnD
0 Replies
3. Solaris
Got a strange problem.
I have 4 Solaris servers all configured the same, Solaris 10 x86 update 10.
When I try to ssh from one Solaris 10 server to another server ssh hangs.
I have an identical server and when I try this everything works fine.
The weird thing is if I am root on the server... (1 Reply)
Discussion started by: ccj4467
1 Replies
4. Shell Programming and Scripting
I'm brand new to awk and need your help.
I want to be able to shut down my workstations when they become to hot (because we've lost our cooling). I found a really neat way to monitor the temperature of the system and a short, simple awk scipt to use with it:
/usr/sbin/prtpicl -v -c... (2 Replies)
Discussion started by: natural
2 Replies
5. Shell Programming and Scripting
Is there a way to call a shell script via db2 trigger?
I want to wake up a shell script to perform some action if there is a insert action on a db2 table. (1 Reply)
Discussion started by: prasperl
1 Replies
6. Solaris
Hi,
I am unable to login into my terminal hosting Solaris 10 and get the below error message
"Server refused to allocate pty
ld.so.1: sh: fatal: libc.so.1: open failed: No such file or directory "
Is there anyways i can get into my machine and what kind of changes are required to be... (7 Replies)
Discussion started by: sankasu
7 Replies
7. Shell Programming and Scripting
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)
Discussion started by: tjhanso
1 Replies
8. IP Networking
This is probably really basic compared to what you guys are usually talking about here, but I have a problem and I have no idea what to do about it. I try to RSH to my Ubuntu computer from my Solaris one and run into a dead end:
>> rsh 192.168.1.103
::ffff:192.168.1.103: Connection timed out... (4 Replies)
Discussion started by: Bradj47
4 Replies
9. Solaris
hi,
I have some windows client machines which require a signal to be sent by a Solaris machine( SunOS 5.6) when ever a particular event occurs on that Solaris machine. What are possible communication mechanisms by which i can do this.
the constraints are
> the windows machines have to... (7 Replies)
Discussion started by: Krsh
7 Replies
10. UNIX for Dummies Questions & Answers
Hi...
I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'... (0 Replies)
Discussion started by: Sujatha Gowda
0 Replies
DB2_CLIENT_INFO(3) 1 DB2_CLIENT_INFO(3)
db2_client_info - Returns an object with properties that describe the DB2 database client
SYNOPSIS
object db2_client_info (resource $connection)
DESCRIPTION
This function returns an object with read-only properties that return information about the DB2 database client. The following table lists
the DB2 client properties:
DB2 client properties
+---------------------+--------------------------------------+---+
| Property name | | |
| | | |
| | Return type | |
| | | |
| | Description | |
| | | |
+---------------------+--------------------------------------+---+
| APPL_CODEPAGE | | |
| | | |
| | int | |
| | | |
| | The application code page. | |
| | | |
| CONN_CODEPAGE | | |
| | | |
| | int | |
| | | |
| | The code page for the current con- | |
| | nection. | |
| | | |
| DATA_SOURCE_NAME | | |
| | | |
| | string | |
| | | |
| | The data source name (DSN) used to | |
| | create the current connection to the | |
| | database. | |
| | | |
| DRIVER_NAME | | |
| | | |
| | string | |
| | | |
| | The name of the library that imple- | |
| | ments the DB2 Call Level Interface | |
| | (CLI) specification. | |
| | | |
| DRIVER_ODBC_VER | | |
| | | |
| | string | |
| | | |
| | The version of ODBC that the DB2 | |
| | client supports. This returns a | |
| | string "MM.mm" where $MM is the | |
| | major version and $mm is the minor | |
| | version. The DB2 client always | |
| | returns "03.51". | |
| | | |
| DRIVER_VER | | |
| | | |
| | string | |
| | | |
| | The version of the client, in the | |
| | form of a string "MM.mm.uuuu" where | |
| | $MM is the major version, $mm is the | |
| | minor version, and $uuuu is the | |
| | update. For example, "08.02.0001" | |
| | represents major version 8, minor | |
| | version 2, update 1. | |
| | | |
|ODBC_SQL_CONFORMANCE | | |
| | | |
| | string | |
| | | |
| | The level of ODBC SQL grammar sup- | |
| | ported by the client: | |
| | | |
| | o MINIMUM | |
| | - Supports the mini- | |
| | mum ODBC SQL gram- | |
| | mar. | |
| | | |
| | o CORE | |
| | - Supports the core | |
| | ODBC SQL grammar. | |
| | | |
| | o EXTENDED | |
| | - Supports extended | |
| | ODBC SQL grammar. | |
| | | |
| ODBC_VER | | |
| | | |
| | string | |
| | | |
| | The version of ODBC that the ODBC | |
| | driver manager supports. This | |
| | returns a string "MM.mm.rrrr" where | |
| | $MM is the major version, $mm is the | |
| | minor version, and $rrrr is the | |
| | release. The DB2 client always | |
| | returns "03.01.0000". | |
| | | |
+---------------------+--------------------------------------+---+
PARAMETERS
o $connection
- Specifies an active DB2 client connection.
RETURN VALUES
Returns an object on a successful call. Returns FALSE on failure.
EXAMPLES
Example #1
A db2_client_info(3) example
To retrieve information about the client, you must pass a valid database connection resource to db2_client_info(3).
<?php
$conn = db2_connect( 'SAMPLE', 'db2inst1', 'ibmdb2' );
$client = db2_client_info( $conn );
if ($client) {
echo "DRIVER_NAME: "; var_dump( $client->DRIVER_NAME );
echo "DRIVER_VER: "; var_dump( $client->DRIVER_VER );
echo "DATA_SOURCE_NAME: "; var_dump( $client->DATA_SOURCE_NAME );
echo "DRIVER_ODBC_VER: "; var_dump( $client->DRIVER_ODBC_VER );
echo "ODBC_VER: "; var_dump( $client->ODBC_VER );
echo "ODBC_SQL_CONFORMANCE: "; var_dump( $client->ODBC_SQL_CONFORMANCE );
echo "APPL_CODEPAGE: "; var_dump( $client->APPL_CODEPAGE );
echo "CONN_CODEPAGE: "; var_dump( $client->CONN_CODEPAGE );
}
else {
echo "Error retrieving client information.
Perhaps your database connection was invalid.";
}
db2_close($conn);
?>
The above example will output:
DRIVER_NAME: string(8) "libdb2.a"
DRIVER_VER: string(10) "08.02.0001"
DATA_SOURCE_NAME: string(6) "SAMPLE"
DRIVER_ODBC_VER: string(5) "03.51"
ODBC_VER: string(10) "03.01.0000"
ODBC_SQL_CONFORMANCE: string(8) "EXTENDED"
APPL_CODEPAGE: int(819)
CONN_CODEPAGE: int(819)
SEE ALSO
db2_server_info(3).
PHP Documentation Group DB2_CLIENT_INFO(3)