Topic
  • 5 replies
  • Latest Post - ‏2013-10-31T20:57:10Z by jrniemijr
muras
muras
1 Post

Pinned topic CREATE DATABASE very slow (v10.1 fp2)

‏2013-03-19T19:54:30Z |
db2 CREATE DATABASE myTest AUTOMATIC STORAGE YES ON '/home/db2inst1' DBPATH ON '/home/db2inst1' USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM PAGESIZE 8192

Hi - the CREATE DATABASE command (above) is very slow taking about 8 minutes on my laptop where I have V10.1 fixpack2 running on Redhat linux (64 bit), Memory 3.6 Gig, 4 processors 2.5 GHz

We have linux guest VMs running where it takes 30+ minutes with local disks (datastore) configured.

Is this expected? is there anything I can do to speed it up?

I have tried changing the DB2_PARALLEL_IO to different values, and also specifying: AUTOCONFIGURE APPLY NONE, but these do not improve the runtime.

-thanks in advance for any assistance :-)
brian
  • Sreeharsha_Naik
    Sreeharsha_Naik
    8 Posts

    Re: CREATE DATABASE very slow (v10.1 fp2)

    ‏2013-05-09T20:14:34Z  

    Hi Brain,

    I have had this issue on DB2 10.1.2 on windows - express C when I moved from 64 bits to 32 bits. It was strange - the create db sample command would take < a minute in my colleagues laptop but in mine it would take > 5 minutes. I rolled back to 64 and everything was back to normal. At times it would be unusually long on 64 as well. Some experts pointed out about disk fragmentation on windows, other said that the CPU was busy with services/applications. I am not familiar with Linux, may be it should give you a heads up on something, hopefully - till then we will wait for some good answer :)

    Regards,
    Sreeharsha

  • jrniemijr
    jrniemijr
    2 Posts

    Re: CREATE DATABASE very slow (v10.1 fp2)

    ‏2013-10-30T17:41:13Z  

    Is there any update on this extremely slow db creation on RHEL 6.4  x86_64?

    I am seeing similar slow times with db2 10.5 FP2.

    Simple sample db taking ~20 mins on some systems.

    It does not seem to matter if it is real hardware vs. a VM.

    Some systems create the db in 1-2 mins and others it takes 20+ mins.

    Is it disk/storage related? excessive writes to disk?

  • 9RYQ_Kiran_mk
    9RYQ_Kiran_mk
    78 Posts

    Re: CREATE DATABASE very slow (v10.1 fp2)

    ‏2013-10-31T07:22:40Z  
    • jrniemijr
    • ‏2013-10-30T17:41:13Z

    Is there any update on this extremely slow db creation on RHEL 6.4  x86_64?

    I am seeing similar slow times with db2 10.5 FP2.

    Simple sample db taking ~20 mins on some systems.

    It does not seem to matter if it is real hardware vs. a VM.

    Some systems create the db in 1-2 mins and others it takes 20+ mins.

    Is it disk/storage related? excessive writes to disk?

    I guess 8 minutes is not a long time for DB Creation.  But still its not ideal  I would also interested to know whether you are running any other services which consumes more resources.

     

    Best Regards,

    Kiran.M.K.

  • 9RYQ_Kiran_mk
    9RYQ_Kiran_mk
    78 Posts

    Re: CREATE DATABASE very slow (v10.1 fp2)

    ‏2013-10-31T07:23:57Z  
    • jrniemijr
    • ‏2013-10-30T17:41:13Z

    Is there any update on this extremely slow db creation on RHEL 6.4  x86_64?

    I am seeing similar slow times with db2 10.5 FP2.

    Simple sample db taking ~20 mins on some systems.

    It does not seem to matter if it is real hardware vs. a VM.

    Some systems create the db in 1-2 mins and others it takes 20+ mins.

    Is it disk/storage related? excessive writes to disk?

    I guess 8 minutes is not a long time for DB Creation.  But still its not ideal  I would also interested to know whether you are running any other services which consumes more resources.

     

    I believe VM give lesser performance in local system when compared to VM's running on High End Servers.  This could be one of the reason. But not sure.

     

    Best Regards,

    Kiran.M.K.

  • jrniemijr
    jrniemijr
    2 Posts

    Re: CREATE DATABASE very slow (v10.1 fp2)

    ‏2013-10-31T20:57:10Z  

    I guess 8 minutes is not a long time for DB Creation.  But still its not ideal  I would also interested to know whether you are running any other services which consumes more resources.

     

    I believe VM give lesser performance in local system when compared to VM's running on High End Servers.  This could be one of the reason. But not sure.

     

    Best Regards,

    Kiran.M.K.

    Sorry that I did not provide better details. The 8 min db creation is for like a sample db. Nothing to it. Should take like seconds to create.

    When we get to databases that are part of product is when it takes 20+ mins but on other systems, the same db creation takes a couple of minutes.

    There are many variables at play here even with different hardware involved which is making it hard to debug.

    Some systems have SSD and others regular hdds. Which is why we tried changing the I/O scheduler settings from cfq to noop to deadline.

    Not any improvement in times.

    The slowest time is actually on real hardware with a ssd.