Hello, Monks...

I suddenly find myself having to use DB2 in a new work environment. The DB2 server is far, far away, and also a Solaris box. I wish to develop my programs on my local RedHat 9 workstation, which I will ultimately transfer over to the Solaris box. While developing the programs I wish to remotely connect to the DB2 server on that machine via DBI/DBD::DB2.

How can this be done?

I have read in the perldoc for DBD::DB2 that there is this mysterious thing called a "catalog" that should be on my local machine from which DBD::DB2 would read the connection parameters to the remote DB2 server. Talking with the DB2 administrator here, he says that installing a catalog on my local machine would require installing DB2 on my local machine, and setting up DB2 server replication.

This sounds like insane overkill to me. (Quite apart from the fact that we have the software & license for DB2 on the Solaris machine, but none for the local RedHat boxen.)

Isn't there something akin to simply specifying a hostname and port in the DBI connect string (per MySQL)? And perhaps additionally specifying a few environment variables (per Oracle)?

Apologise if this question has been asked here before. ('Search' didn't yield anything particularly similar.) I did about an hour of searching the 'net at large, mailing list archives, etc. as well, but everything I ever read pointed to the "catalog".

Cheers,
Richard

In reply to remote connections to DB2 database via DBI/DBD::DB2 by Dice

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.