• State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 25 subscribers
  • Views 577 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Solarwinds ODBC

skenny

Can the connection string "Driver={IBM DB2 ODBC DRIVER};" and the sql query

SELECT SUM(TABLE_SCANS)
FROM TABLE(MON_GET_TABLE('','',-1))

be replaced not using ODBC, but being restricted to using


DBI DBD::mysql  DBD::Sponge  DBD::Proxy  DBD::Pg DBD::Gofer  DBD::File   DBD::DBM 

  • 0

    skenny wrote:

    DBI DBD::mysql DBD::Sponge  DBD::Proxy  DBD::Pg DBD::Gofer  DBD::File   DBD::DBM 

    I wouldn't think that a MySQL driver would work terribly well with a DB2 database?

  • 0

    Is this in relation to DPA or SAM? We don't usually see a driver specified in the connection string as we will use the one we ship with, but I can ask engineering if need be. I just need some clarification on where you are specifying this and in what product?

  • 0

    It sounds like you are trying to use the DB2 template for SAM.  Unfortunately, that template uses only the ODBC driver.  However, there is nothing stopping you from creating a custom template that would allow you to issue that query using DBD::DB2 using perl. 

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.