To homepage To homepage
Solved

DB2 connector querying the wrong schema when selecting tables

  • 16 February 2023
  • 8 replies
  • 129 views
anders.e.jonsson
Rank
Userlevel 1
Badge +1

We have set up a db2 connector in an installation with the new version of Timextender. The connection is ok.When we make a search to select tables, nothing turns up. Both the schema and table filters are set to <All>.
It seems that Timextender searches the schema [sys_tables], but the server uses the schema [systables]. Without the underscore.The schema [sys_tables] exists on the server, but contains no data. I created a Query Table (Select * from [sys_tables]). It was executed succesfully in a Transfer task, but only returned empty columns.
Is it possible to change the script so that the query uses the schema systables?
I couldn't find anything about it in CData's online manual
The Timextender version is 6143.1, and the CData DB2 version is 22.0.8389.9

icon

Best answer by Thomas Lind 30 March 2023, 15:34

View original
Anders

8 replies

rvgfox
Rank
Userlevel 3
Badge +1

In my experience, I’m using a Linked server with OLE DB connector (Client Access) to connect to our AS/400 (iSeries v5r4) several years ago, and now, with TX this setup works perfectly using the SQL TimeXtender connector.

anders.e.jonsson
Rank
Userlevel 1
Badge +1

Thanks rvgfox. We will try that.

Anders
Thomas Lind
Rank
Userlevel 5
Badge +5

Hi Anders

Alternatively I can ask CData to explain what can be done when a setup is for Sys_Tables instead of SysTables.

I would need a log for what happens when you synchronize to possibly make it show that it do not contain.

anders.e.jonsson
Rank
Userlevel 1
Badge +1

Hi Thomas,

Thanks! We’ will try linked server first. If that doesn’t work I’ll get back with log files.

Anders
anders.e.jonsson
Rank
Userlevel 1
Badge +1

Hi  @Thomas Lind ,

I have attached a log file.

The DB2 version is 9,7, and is installed on a Windows server.

When the customer tested Timextender V20 last autumn, the DB2 connector included worked fine. Unfortunately it’s uninstalled, so I don’t know which version of CData’s connector it was.

 
1 Attachment
Anders
Thomas Lind
Rank
Userlevel 5
Badge +5

Hi Anders

I have asked CData.

Thomas Lind
Rank
Userlevel 5
Badge +5

Hi Anders

Just an update regarding the current progress of this issue.
Hi Thomas,

I sent this to our development team for further review. I will keep you posted as soon as I have an update.

Regards,
Quinn Freas

Thomas Lind
Rank
Userlevel 5
Badge +5

Hi Anders

Just an update to this, as we have a Zendesk ticket regarding this.

It was possible to use a default ODBC data source that used a DB2 provider set up on the server.

It has some additions that would make it work better, but it does work as a method to gain access to a DB2 data source in the new version of TimeXtender (i.e. v 6xxx).

Reply


Terms and ConditionsCookie settings