DBSPACETEMP IN SDS CLUSTER

I have a Cluster SDS, secondary server is setup as UPDATABLE_SECONDARY 1 my application is connected through CM, When an user is connected to Secondary Server i recived. -229 Could not open or create a temporary file. -131 ISAM error: no free disk space. I checked "onstat -d" and i see that dbspaces temp is showed like disable, my workaround now is setup DBSPACETEMP=DBSPACETEMP(primary)+ SDS_TEMPDBS(Secondary), although online.log now show 16:26:53 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed in DBSPACETEMP: 'temp_pepsico_01_dbs' 16:26:53 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed in DBSPACETEMP: 'temp_pepsico_02_dbs' 16:26:53 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed in DBSPACETEMP: 'temp_pepsico_03_dbs' 16:26:53 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed in DBSPACETEMP: 'temp_pepsico_04_dbs' 16:26:53 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed in DBSPACETEMP: 'temp_pepsico_05_dbs' Somebody can help me?

Original Post: I have a Cluster SDS, secondary server is setup as UPDATABLE_SECONDARY 1 my application is connected through CM, When an user is connected to Secondary Server i recived. -229 Could not open or create a temporary file. -131 ISAM error: no free disk space. I checked "onstat -d" and i see that dbspaces temp is showed like disable, my workaround now is setup DBSPACETEMP=DBSPACETEMP(primary)+ SDS_TEMPDBS(Secondary), although online.log now show 16:26:53 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed in DBSPACETEMP: 'temp_pepsico_01_dbs' 16:26:53 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed in DBSPACETEMP: 'temp_pepsico_02_dbs' 16:26:53 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed in DBSPACETEMP: 'temp_pepsico_03_dbs' 16:26:53 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed in DBSPACETEMP: 'temp_pepsico_04_dbs' 16:26:53 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed in DBSPACETEMP: 'temp_pepsico_05_dbs' Somebody can help me? Response: You need to configure SDS_TEMPDBS properly on your SDS secondary server. See http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=%2Fcom.ibm .admin.doc%2Fids_admin_0914.htm for more info. Jacques Renaut IBM Informix Advanced Support APD Team

Hi Leonardi, I don't think you should put the temp dbspaces listed in the SDS_TEMPDBS of secondary in DBSPACETEMP. My guess is that those errors are triggered by that. Can you please try just setting DBSPACETEMP=DBSPACETEMP(primary)and bounce the server? The errors should be likely going away. Regards, Ken