Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399

    Unanswered: v9.5 new dbm cfg params - 'Number compatibility' and 'Varchar compatibility'?

    We migrated our databases from v8.2 to v9.5. I did 'get dbm cfg' and found new dbm cfg parameters in v9.5:

    - Number compatibility; and
    - Varchar2 compatibility.

    set to OFF in our case.

    What are they? I could not find any description on them anywhere.

    Are they just informational? Or they do matter?

    Thanks in advance
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I believe these belong to the Oracle compatibility package. I guess you can disregard them unless you are migrating something from Oracle to DB2.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    thank you, Nick
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    As Nick mentioned, they're related to the new compatability features in v9.5. For example, if you set DB2_COMPATIBILITY_VECTOR to 3F (db2set DB2_COMPATIBILITY_VECTOR=3F) prior to creating the db, then they'll be set to ON (these are db cfg parameters).

    You can check the following links for some additional info:

    DB2 Viper 2 compatibility features
    http://download.boulder.ibm.com/ibmd...lPortGuide.pdf

Posting Permissions

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