Oninit cdi / Archive
Talk to an expert →

question on SBSPACENAME and SYSSBSPACENAME

Posted in 2014

Topics: Storage & Space Management

John Adamski — — source: IIUG Forums & Mailing Lists

I recently added our first subspace and wondering about SBSPACENAME and SYSSBSPACENAME in the onconf file. My assumption is I set the SBSPACENAME to the smart-blob dbspace name (in my case: sdbs0) so the system has a default and the developers don't have to specify which sbspace in their sql. Also assuming this is a good idea to do. For SYSSBSPACENAME what are the advantage or disadvanage to specifying a sbspace? I guess I'm not sure if I should or shouldn't specify our sdbs0. John David Adamski, Sr. Network Specialist Graceland University, 1 University Place, Lamoni, IA 50140 adamski@graceland.edu 641.784.5267

↪ replying to John Adamski
Art Kagel — — source: IIUG Forums & Mailing Lists

If you have fragmented/partitioned tables and the other criteria are met, then the engine needs an sbspace named in SYSSBSPACENAME into which to put distributions for your table partitions. If it is not set then partitioned tables can only get table level distributions. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jan 9, 2014 at 11:16 AM, John Adamski <adamski@graceland.edu> wrote: > I recently added our first subspace and wondering about SBSPACENAME and > SYSSBSPACENAME in the onconf file. > > My assumption is I set the SBSPACENAME to the smart-blob dbspace name (in > my > case: sdbs0) so the system has a default and the developers don't have to > specify which sbspace in their sql. Also assuming this is a good idea to > do. > > For SYSSBSPACENAME what are the advantage or disadvanage to specifying a > sbspace? I guess I'm not sure if I should or shouldn't specify our sdbs0. > > John David Adamski, Sr. Network Specialist > Graceland University, 1 University Place, Lamoni, IA 50140 > adamski@graceland.edu > 641.784.5267 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11341542f035be04ef8c235d

Glossary