DB2 Connections?

From: schnarff (alex_at_schnarff.com)
Date: 02/21/05 

Date: 21 Feb 2005 08:17:23 -0800

Hello All,

I realize this may be more of a DB2 question than a Perl DBI one, but
I've had zero success dealing with DB2 public forums, and given that
the Perl community has always been friendly, I thought I might get
lucky asking my question here.

My situation is pretty straightforward. I've got an IBM DB2 v8.1
Express Edition database set up on a Windows 2000 Server system. I used
the wizard to install, and picked all defaults. I'm able to connect to
the database just fine through the local Control Center; from there,
all appears well.

However, when I attempt to use DBD::DB2 to connect to this system, I
run into a very weird error. I'm able to connect to the database -- the
DBI->connect(...) method succeeds every time. However, when I try even
the most basic of SQL statements -- say, "select * from
sample.emp_acct" -- I get this error every time:

DBD::DB2::db prepare failed: [IBM][CLI Driver] SQL0901N The SQL
statement failed because of a non-severe system erorr. Subsequent SQL
statements can be processed. (Reason "Unsupported function for SPMDB
connect".) SQLSTATE=58004

Now, I've looked all over the web for the SQL code/SQLSTATE, and
neither are specific to any one condition. I've also looked for the
reason given here, and there is *nothing* except one post to a mailing
list from a few years back that says "call IBM" (which I can't do
because I don't have support). That said, I'm totally stuck here. Does
anyone have any idea what could be going on here, or how to fix it?

Thank You,
Alex Kirk

Relevant Pages

  • Re: COBOL stored procedure for DB2
    ... Regarding how you precompile the app, you must specify target mfcob to db2 prep, rather than target ibmcob. ... Have you also confirmed that, prior to executing the CALL statement, the host variables specified within the client app have the appropriate values? ... MODIFIES SQL DATA ... confirm the cob command used for creating the SP module. ...
    (comp.lang.cobol)
  • Re: Accessing SQl files by a RPG program or something else ?
    ... I don't mind you recommending a non-IBM solution to the problem. ... DB2 Connect does not support the access of SQL Server tables, ... known as the SQL Call Level Interface, ...
    (comp.sys.ibm.as400.misc)
  • Re: MSAS 2000 Read Time (64 bit) ; DB: DB2
    ... SQL BI Product Unit ... > I already have the advanced filter set to each of the partition slices. ... > I want to correct some of my MSAS Read time stats that I mentioned in my ... > close to 150 K rows per minute from DB2. ...
    (microsoft.public.sqlserver.olap)
  • Re: COBOL stored procedure for DB2
    ... Have you also confirmed that, prior to executing the CALL statement, the ... The DB2 CREATE PROCEDURE statement. ... MODIFIES SQL DATA ... confirm the cob command used for creating the SP module. ...
    (comp.lang.cobol)
  • VARCHAR columns in COBOL
    ... I'm just learning about embedded SQL, ... the DB2 Programming Client Applications manual leads me to believe ... variables dbname and userid will have any trailing blanks removed before ... However, because blanks can be significant in passwords, the p-word host ...
    (comp.lang.cobol)