How to call a DB2 SP from Solaris machine.

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Call Anonymous block from DB2

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...

2. Solaris

Solaris backup machine

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...

3. Solaris

Solaris ssh client hangs when connecting to another Solaris machine

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...

4. Shell Programming and Scripting

System call using awk on Solaris

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...

5. Shell Programming and Scripting

How to call shell script from db2 triggger

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.

6. Solaris

Unable to login using ssh,telnet onto my solaris machine with solaris 10 installed

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. Shell Programming and Scripting

Unix Korn Shell script on Solaris to DB2 UDB LUW database

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...

8. IP Networking

RSH to Ubuntu machine from Solaris machine?

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...

9. Solaris

Best possible communication mechanism between a Solaris machine and a windows machine

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...

10. UNIX for Dummies Questions & Answers

Exception while loading DB2 driver Class.forName("com.ibm.db2.jcc.DB2Driver")

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'...

LEARN ABOUT PHP

db2_pclose

DB2_PCLOSE(3)								 1							     DB2_PCLOSE(3)

db2_pclose - Closes a persistent database connection

SYNOPSIS

       bool db2_pclose (resource  $resource)

DESCRIPTION

	This function closes a DB2 client connection created with db2_pconnect(3) and returns the corresponding resources to the database server.

       Note

	       This function is only available on i5/OS in response to i5/OS system administration requests.

	If  you  have a persistent DB2 client connection created with db2_pconnect(3), you may use this function to close the connection. To avoid
       substantial connection performance penalties, this function should only be used in rare cases when the  persistent  connection  has  become
       unresponsive or the persistent connection will not be needed for a long period of time.

PARAMETERS

	      o $connection
		- Specifies an active DB2 client connection.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Closing a persistent connection

	       The following example demonstrates a successful attempt to close a connection to an IBM DB2 i5/OS database.

	      <?php
	      $conn = db2_pconnect('', '', '');
	      $rc = db2_pclose($conn);
	      if ($rc) {
		  echo "Connection was successfully closed.";
	      }
	      ?>

	      The above example will output:

	      Connection was successfully closed.

SEE ALSO

       db2_close(3), db2_pconnect(3).

PHP Documentation Group 													     DB2_PCLOSE(3)

Linux