Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2008
    Posts
    45

    Unanswered: client missing the columns

    Hi friends,

    we noticed a strange issue for one of our applications.Client was not seeing 2 columns newly added although they are visible from server side...Another issue we noticed is that , I un enforced constraints and the client is not picking up that..This is happening for that particular database alone..

    Thanks

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    First, I would check if they are connecting to the same db as you making changes too. Then to make sure they are using the same tables. If thye are using the same tables, have you checked to make sure that your constraints working properly when you have implemented them?
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Regarding the columns, are you using static SQL and packages?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Jan 2008
    Posts
    45
    No static ones..Also it is ok on the server side and i somehow think that the changes on server are not propogating to client immediately..Any jdbc/odbc issues??

  5. #5
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    did you have them check connection and make sure that they are using the right schema?
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  6. #6
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    There are no "propagation issues". Any client will usually instantly pick up schema changes.

    You should tell us how your client application connects to DB2, how it executes its SQL statements, what those SQL statements are, how you changed the schema at the server, how you verified that the change was successful, whether you have collected a CLI/JDBC trace and what you found there. Furthermore, it would be good if you read the post "Must Read before posting" (http://www.dbforums.com/showthread.php?t=854783) and provide us with the answers to the questions raised there.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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