script to test DB2 runtime client

perldesire has asked for the wisdom of the Perl Monks concerning the following question:

Hi,
I have installed IBM DB2 Run time client version 9.5 in my windows server.

It is been installed properly.
Now I want to check whether DB2 connectivity is proper, by writing some perl scripts.

Kindly give me the steps to be available in that script, to ensure DB2 connectivity is proper.

Thank you in advance.

Comment on script to test DB2 runtime client

Replies are listed 'Best First'.
Re: script to test DB2 runtime client by Corion (Patriarch) on Jun 01, 2009 at 14:51 UTC
The general approach to doing such checks is to first identify what steps you would take manually, and second to write programs to retake those steps automatically. As we don't know what steps you would take yourself to ensure that DB2 connectivity is proper, it would help us to help you better if you told us what steps you would take yourself to ensure that DB2 connectivity is proper. For a general idea I can point you towards the DBI documentation, as I would issue some `select` statements through DBI to check that the DB2 connectivity is proper.	[reply] [d/l]

Replies are listed 'Best First'.

Re: script to test DB2 runtime client
by Corion (Patriarch) on Jun 01, 2009 at 14:51 UTC

The general approach to doing such checks is to first identify what steps you would take manually, and second to write programs to retake those steps automatically.

As we don't know what steps you would take yourself to ensure that DB2 connectivity is proper, it would help us to help you better if you told us what steps you would take yourself to ensure that DB2 connectivity is proper. For a general idea I can point you towards the DBI documentation, as I would issue some select statements through DBI to check that the DB2 connectivity is proper.

[reply]
[d/l]