Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150

    Unanswered: DB2 Table design

    I have a colleague that is insisting on creating 30 tables that have the same structure and the only difference is the name, i.e all columns are the same but the name of the table 1 is abc and table 2 is def and so on and so. They are trying to tell me that this design is based on the fact that these 30 tables need to be separated by the identifier i.e what the tablename is representing because it allows the batch processing that runs to run concurrently and avoids deadlocks on the table(s). Now I don't want to have 30 tables of the same structure just because they want to avoid deadlock issues on inserts/reads during the processing window. Just trying to get another opinion on best practices. This is Db2 9.5 on AIX 6.1

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Best practice is to not use a DB2 version that is no longer supported by IBM.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150
    My company pays for extra support and that didn't answer my question

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •