Skip to Content
Author's profile photo Gi-sung Jang

[SHARE] How to rename IQMSG file on existing IQ.

Hi,

We sometimes need to rename the iqmsg file.

Here are steps to rename the iqmsg file

1) Find a dbfile name with sysdbfile.

   >> select * from sysdbfile ;

   dbfile_id,dbspace_id,dbfile_name,file_name,lob_map

   16386,16386,’IQ_SYSTEM_MSG‘,/home1/iq154/DEV/TEST.iqmsg,

2) Rename the iqmsg file using alter dbspace command as follows.

   

   ALTER DBSPACE IQ_SYSTEM_MSG

   ALTER FILE IQ_SYSTEM_MSG — dbfile_name

   RENAME PATH ‘/home1/iq154/DEV/TEST_NEW.iqmsg’; — NEW IQMSG FILE PATH/NAME

3) Need to restart IQ.

  

    You can verify the renamed iqmsg file after rebooting IQ.

    >> ls -al *.iqmsg

    /home1/iq152/DEV>> ls -al *.iqmsg

         -rw-r–r–   1 iq152      syb        23140744 Feb 12 17:11 TEST.iqmsg

         -rw-r–r–   1 iq152      syb          55815 Feb 12 17:25 TEST_NEW.iqmsg

4) Please remove or move the old iqmsg file.

HTH

Gi-Sung Jang

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Roland Kramer
      Roland Kramer

      Hi,
      Can I add this hint to the following Document? SAP First Guidance – SAP-NLS Solution with SAP IQ

      Best Regards Roland

      Author's profile photo Gi-sung Jang
      Gi-sung Jang
      Blog Post Author

      Hi,

      Sure, No problem.

      Best Regards,
      Gi-Sung Jang