Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2010
    Posts
    1

    Unanswered: Create Statement Taking Too Long

    I just installed db2, db2level gives the following

    DB21085I Instance "tyler" uses "64" bits and DB2 code release "SQL09070" with
    level identifier "08010107".
    Informational tokens are "DB2 v9.7.0.0", "s090521", "LINUXAMD6497", and Fix
    Pack "0".
    Product is installed at "/opt/ibm/db2/V9.7".

    Everything is working fine except how long it takes to create a database. when I run the command 'db2 create database sample' it takes 10 minutes to complete. Anything I can do to reduce this time?? This is a development environment.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Is there some reason you did not run dbsampl program? It comes with a schema and data.

    But I don't know why your create database statement took so long.
    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
    Jul 2009
    Location
    NY
    Posts
    963
    1. You have to defragment your hard drive
    2. Stop another applications which used the hard drive

    Lenny

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by Lenny77 View Post
    1. You have to defragment your hard drive
    2. Stop another applications which used the hard drive

    Lenny
    I wasn't aware one could defrag a Linux hard drive, but I am not Linux expert. I suspect it is just a problem with the base level fixpack 0 code.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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