Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
Gisung
Advisor
Advisor

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

2 Comments