Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2016
    Posts
    4

    Unanswered: I an Dummy, need advise on DB2 express C 11.1

    Hello Every one
    i am from the back ground of MySql and .net plat form for a while and have some experience

    MySql is good enough for a mid sized application, but it's not full fledged, say for example it doesn't support FULL OUTER JOIN.
    but other than that it's works great.

    i would like to know
    how its best to switch over from MySql to DB2 express 11.1
    in terms of security and Speed.

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    DB2 is a full featured database-engine as are Oracle and SQL-Server. The Express-C has limitations on RAM-size (16gb) and number-of-cores (2). Those limitations might impact your application, but you posted no numbers about your database metrics. DB2 authentication (of userid/password) is done either by the operating-system or centralised-authentication (ldap, kerberos...) and the SQL syntax follows ANSI SQL standards mostly which could mean changes to your application. So it's not only a matter of speed or security but the cost to migrade both the code and the data, and the long term support issues.

  3. #3
    Join Date
    Jul 2016
    Posts
    4

    Thanks for the reply

    is there 32 bit express c version 11.1

  4. #4
    Join Date
    Jul 2016
    Posts
    4

    Client tools

    Other than DB2 studio what are other options please

  5. #5
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Quote Originally Posted by makemerain View Post
    is there 32 bit express c version 11.1
    Try : http://www.ibm.com/developerworks/do...im/db2express/

    seems to have both 32-bit and 64-bit options

  6. #6
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Quote Originally Posted by makemerain View Post
    Other than DB2 studio what are other options please
    Have you tried Google? db-visualizer, toad for db2, squirrel sql - anything that works with plain jdbc 4 has a good chance of working with DB2 if properly configured

  7. #7
    Join Date
    Jul 2016
    Posts
    4

    No 32 bit

    thanks for many replies
    i have downloaded and checked the express c 11.1 it only works with 64 bit OS, there is no 32 bit package.

Posting Permissions

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