Results 1 to 5 of 5

Thread: 32bit to 64bit

  1. #1
    Join Date
    Apr 2004
    Posts
    190

    Unanswered: 32bit to 64bit

    Is there anything that must be done to make db2 databases 64bit after running db2iupdt -w 64 to update the instance to 64bit ? I'm on db2 v8.2 Fixpack 9, and Solaris OS.

    Thanks

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    64b

    no db2iupdt is enough
    just verify the .profile if any setting specific to lib32
    lib is default and in your case 64b
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Apr 2004
    Posts
    190
    Would I have to rebind packages?

  4. #4
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Arrow Yes

    I think its necessary to rebind everything
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  5. #5
    Join Date
    Mar 2003
    Posts
    343
    On AIX, we had to chage the data and stack settings of instance id, data to unlimited, stack to 32768. It may help to find out what the values should be for your platform.
    You may need to make some configuration changes since the pointers become larger. We noticed that the number of deadlocks increased. There were some other config changes which we made, however, we did add memory to the servers. We increased FCM parms, sortheap, doubled buffpage, dbheap.

    HTH
    Last edited by cchattoraj; 08-10-06 at 11:38.

Posting Permissions

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