DB2 Multi-Member Data Source

Answered

Subbiah Arunachalam

• January 25, 2022 18:11

Do anyone have experience in extracting DB2 Multi-member table ?

We have setup ODBC using IBM i Series driver, and see its only extracting data from only 1 member. On a bit of research there is no given way we can acheive with simple ODBC connection. we are exploring use of Showcase ODBC and also creating an alias and an union view

Before we reinvent the wheel, wanted to check if anyone has done this before and any pointers

0

• Best answer

  

  Subbiah Arunachalam

  • March 09, 2022 02:35

  UPDATE : we ended up with the team creating ALIAS for the Multi-member. each Alias for the Multi-member was extracted into DB. the same sdb was used as a source and a Manual Cranport was setup with UNION view of all the Multi-member tables for the object and consolidated into 1 table

  0
• 

  Ben Bauer

  • January 27, 2022 12:05
  • Edited

  Hi Subbiah,

  I don't see any other cases or posts here that have dealt with multi-member tables in DB2, but I do see some general advice online that suggests using a tool (DB2 Multisystem) to convert multi-member tables into partitioned tables.

  https://dba.stackexchange.com/questions/150677/select-all-data-from-ibm-db2-member-table

  I hope you find the information helpful!

  1
• 

  Subbiah Arunachalam

  • January 27, 2022 03:35

  Thanks Ben for the info, this helps to confirm that we have to either change the way DB2 is storing data or Create Alias for each member and extract each Alias and combine it in Collect

  1
• 

  Ben Bauer

  • March 10, 2022 17:12

  Hi Subbiah,

  Thank you for posting the final outcome! I'm glad to hear the task was completed.

  0

Please sign in to leave a comment.