Hi Mark
It's normal ! TSM DB is not a DB2 one. It is based on B-tree and
I've already tried to write a DBI::TSM driver. 99% of the job is
done but one out of 10 commands in the ODBC connection procedure
is different fro TSM. So I could not achieve my work.
When I have more time, I will ask a ODBC guru to help me to finish
my driver. At this time, if your admin box is NT, just install ODBC
and try to connect using this... But I did not manage to either using
PERL / PHP.
Keep in touch
rv
> -----Message d'origine-----
> De : Mark A. Adams [mailto:[EMAIL PROTECTED]]
> Envoyé : mercredi 6 juin 2001 22:43
> À : [EMAIL PROTECTED]
> Objet : DBI Connections to TSM database
>
>
> I am running AIX 4.3.3.x with version 3.7.4 TSM.
> I need to connect to the TSM database using perl, using the
> DBI and the
> DBD::DB2 module.
> I am having trouble connecting to the database. Could anyone
> give me a hand.
>
> CODE
> #!/usr/local/bin/perl
>
> use DBI;
> use DBD::DB2::Constants;
> use DBD::DB2;
>
> $db = DBI->connect("dbi:DB2:adsmsrv1", user, password);
> if (!defined($db)) {
> print "Error connecting to server1 \n";
> #print "Error: " . DBD::DB2::Error(). "\n";
> exit(1);
> }
> exit(0);
> ######################################################
>
> This is the error I am getting.
> DBI->connect(adsmsrv1) failed: Total Environment allocation
> failure! Did
> you set up your DB2 client environment? at ./first.pl line 7
> Error connecting to server1
> #########################
>
> Does any one have any ideas or could help me out?
>
> Mark Adams
> Systems Programmer
> CSG Systems, Inc.
>
