more observations when testing V11.50.UC4

Posted in 2009

Topics: Storage & Space Management, Server Administration

Richard Kofler — Tue, 02 Jun 2009 19:38:48 +0200 — source: Usenet: comp.databases.informix

Hello fellows, today I gave sysadmin and friends a second look. I found this techarticle to be VERY helpful: https://www.ibm.com/developerworks/data/library/techarticle/dm-0709simpson/ Still I miss some good rules of thumb for sizing the sysadmin database. Anyone has some experience already? And I have 1 question regarding sbspaces: I did not find a way to do what -Ms does in onspaces -c -S ... -Ms <size of metadata area>creating a sbspace. When using the SQL API EXECUTE FUNCTION admin ('create sbspace' ...) there are only4 parameters in the docs. I searched thru ibm and did not find anything equivalent for '-Ms' to size the metadata area. Does anyone have any insights on this? dic_k -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe

↪ replying to Richard Kofler

david@smooth1.co.uk — Tue, 2 Jun 2009 12:36:47 -0700 (PDT) — source: Usenet: comp.databases.informix

On 2 June, 18:38, Richard Kofler <richard.kof...@chello.at> wrote: > Hello fellows, > > today I gave sysadmin and friends a second look. > I found this techarticle to be VERY helpful:https://www.ibm.com/developerworks/data/library/techarticle/dm-0709si... > > Still I miss some good rules of thumb for sizing the sysadmin > database. Anyone has some experience already? > > And I have 1 question regarding sbspaces: > I did not find a way to do what -Ms does in > onspaces -c -S ... -Ms <size of metadata area>> creating a sbspace. > > When using the SQL API > EXECUTE FUNCTION admin ('create sbspace' ...) there are only> 4 parameters in the docs. > I searched thru ibm and did not find anything > equivalent for '-Ms' to size the metadata area. > Does anyone have any insights on this? > Not there yet! You also cannot - create temporary sbspaces (their is a create tempdbspace option for temporary dbspaces!). - set the buffering mode for sbspaces - set the lock mode for sbspaces - set the EXTENT SIZE,MIN_EXT_SIZE,NEXT_SIZE for an sbspace via the sql admin API! > dic_k > -- > Richard Kofler > SOLID STATE EDV > Dienstleistungen GmbH > Vienna/Austria/Europe

↪ replying to david@smooth1.co.uk

Neil Truby — Tue, 2 Jun 2009 23:52:40 +0100 — source: Usenet: comp.databases.informix

Dave what's your email address? The smooth1 seems no longer to be valid.

↪ replying to Neil Truby

david@smooth1.co.uk — Tue, 2 Jun 2009 16:38:58 -0700 (PDT) — source: Usenet: comp.databases.informix

On 2 June, 23:52, "Neil Truby" <neil.tr...@ardenta.com> wrote: > Dave what's your email address? > The smooth1 seems no longer to be valid. davidmsdw@yahoo.co.uk

↪ replying to Richard Kofler

david@smooth1.co.uk — Tue, 2 Jun 2009 16:40:14 -0700 (PDT) — source: Usenet: comp.databases.informix

On 2 June, 18:38, Richard Kofler <richard.kof...@chello.at> wrote: > Hello fellows, > > today I gave sysadmin and friends a second look. > I found this techarticle to be VERY helpful:https://www.ibm.com/developerworks/data/library/techarticle/dm-0709si... > > Still I miss some good rules of thumb for sizing the sysadmin > database. Anyone has some experience already? > > And I have 1 question regarding sbspaces: > I did not find a way to do what -Ms does in > onspaces -c -S ... -Ms <size of metadata area>> creating a sbspace. > > When using the SQL API > EXECUTE FUNCTION admin ('create sbspace' ...) there are only> 4 parameters in the docs. > I searched thru ibm and did not find anything > equivalent for '-Ms' to size the metadata area. > Does anyone have any insights on this? > > dic_k > -- > Richard Kofler > SOLID STATE EDV > Dienstleistungen GmbH > Vienna/Austria/Europe What are peoples experiences with IDS 10.00.FC10 and 11.50.FC4? Is anyone using IDS 11 and Kerberos? is anyone using IDS 11 and compresision or the repack/shrink options? David.

Glossary

sbspace