prevent automatic generation of sbspace
Posted in 2019
Topics: Storage & Space Management, Server Administration
How can I prevent automatic generation of SBSPACE and automatic registration of BTS-Modul ? IDS 12.10.FC12 My Instance has no SBSPACE and no datablade is registered in any database. If a 'normal' user with connect right runs (can be accidental) a SQL-Statement like 'SELECT xxx FROM yyy WHERE bts_contains (lname,'Taylor') then automatically a sbspace is created, registered in ONCONFIG, and BTS-Modul is registered in database. How can this be prevented? I don't want a creation of a dbspace or a registration of a datablade due to a user error. TIA Ruediger
Please, or tell me if there is no chance to prevent this. Ruediger
Did a couple of tests, could not stop Informix from auto registering the bts blade and create a sbspace, even with an unprivileged user. The behavior is described in "What's new in DataBlade module installation and registration for Informix, Version 11.70": https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.dmir.doc/i ds_dmir_069.htm Best option is to open a support request with IBM. One possible mitigation would be to create a small sbspace so the automatic blade registration makes use of it, instead of auto creating it outside of the DBA control.
Rename the 'extend' subdirectory under $INFORMIXDIR or rename those blade subdirectories under 'extend' that you do not want to be installable. Then the auto-registration will not work.
Hi Art, bevor my posting I renamed the bts.3.11 directory to no_bts... the sbspace was generated anyway, but the blademgr worked. If I rename the extend-directory, the sbspace will be created but the blademgr gives an error when 'list <database>'. Renaming the directories prevents registering the bts module but not creating the sbspace. That's not what I want.