IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 2 replies
  • Latest Post - ‏2013-02-26T15:15:12Z by nivanov1
SystemAdmin
SystemAdmin
17917 Posts

Pinned topic updating log file path to memory filesystem (tempfs) on RHEL 6.2 x86_64

‏2013-02-25T18:26:31Z |
Hi Team,

created tmpfs of size 100GB
  1. df -h
tmpfs 100G 4.0K 100G 1% /mnt/memfs

$ db2 update db cfg for tradedb using newlogpath /mnt/memfs
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

Changed path to log files (NEWLOGPATH) = /mnt/memfs/NODE0000/LOGSTREAM0000/
Path to log files = /home/db2inst1/db2inst1/NODE0000/SQL00001/LOGSTREAM0000/

Restarted the Database

$ db2 connect to tradedb
SQL1042C An unexpected system error occurred. SQLSTATE=58004

I am getting above error. kindly let me any suggestion on this

Regards
Sharanappa Samal
Updated on 2013-02-26T15:15:12Z at 2013-02-26T15:15:12Z by nivanov1
  • mwandishi
    mwandishi
    47 Posts

    Re: updating log file path to memory filesystem (tempfs) on RHEL 6.2 x86_64

    ‏2013-02-26T06:52:08Z  
    Hi,

    SQL1042C errors are very generic, usually environmental. Typically: permissions, ownerships, missing files etc. You will need to provide the db2diag.log, providing it is not too big. Better still:

    db2 update dbm cfg using diaglevel 4
    db2diag -A ( or mv db2diag.log depending on the version of db2 ).
    db2 connect to tradedb
    db2 update dbm cfg using diaglevel 3
    Then upload the db2diag.log.

    However, have you ensured the path has all the correct permissions / ownerships / mount options? They need to be correct at every level of the filesystem path.

    Best regards,
    Stephen Levett
  • nivanov1
    nivanov1
    231 Posts

    Re: updating log file path to memory filesystem (tempfs) on RHEL 6.2 x86_64

    ‏2013-02-26T15:15:12Z  
    Try setting the registry variable DB2_LOGGER_NON_BUFFERED_IO to OFF.

    You realize, of course, that in case of a system crash you will have very few options recovering your database.