Script for onstat to onspaces

IDS 11.70.FC8XC4 AIX 6.1 Good Morning Folks, I have need to turn all my onstat -d output into onspaces commands. I found a couple of scripts in the repository but they either hang or fail. Does anyone have any reliable script for this that they would consider sharing? The end result is to take an AIX instance with about 500/1500 dbspaces/chunks and move it to an INTEL platform for performance testing. TIA, Dan

dbschema -c -ns infrastructure.ksh -- or --myschema --infrastructure=sql infrastructure.ksh Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 Fri, Sep 16, 2016 at 7:53 AM, DAN MUELLER <ddmueller@west.com> wrote: > IDS 11.70.FC8XC4 > AIX 6.1 > > Good Morning Folks, > > I have need to turn all my onstat -d output into onspaces commands. I > found a > couple of scripts in the repository but they either hang or fail. Does > anyone > have any reliable script for this that they would consider sharing? The end > result is to take an AIX instance with about 500/1500 dbspaces/chunks and > move > it to an INTEL platform for performance testing. > > TIA, > Dan > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --94eb2c194348ffe668053c9ea6f5

Oops, the myschema option should be --infrastructure=cmd Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 Fri, Sep 16, 2016 at 7:55 AM, Art Kagel <art.kagel@gmail.com> wrote: > dbschema -c -ns infrastructure.ksh > -- or --> myschema --infrastructure=sql infrastructure.ksh > > Art > > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.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 Fri, Sep 16, 2016 at 7:53 AM, DAN MUELLER <ddmueller@west.com> wrote: > >> IDS 11.70.FC8XC4 >> AIX 6.1 >> >> Good Morning Folks, >> >> I have need to turn all my onstat -d output into onspaces commands. I >> found a >> couple of scripts in the repository but they either hang or fail. Does >> anyone >> have any reliable script for this that they would consider sharing? The >> end >> result is to take an AIX instance with about 500/1500 dbspaces/chunks and >> move >> it to an INTEL platform for performance testing. >> >> TIA, >> Dan >> >> >> ************************************************************ >> ******************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > --047d7b5d3e0cc6594f053c9ea89c

Ha! Leave it to Art to reveal my lack of proper digging into dbschema. Thanx so much Art. Shoulda though about RTFM here I guess. As always, appreciate the assistance even if it does make me look foolish. (-; Dan

Hi Dan, You can use a dbschema command to do that: dbschema -c -ns Regards, Stuart --- Ardenta Limited is ISO/IEC 20000-1 certified. We are proud to be named IT Supplier Of The Year 2014 and 2013 at eGR B2B Awards. Ardenta Limited is a company registered in England and Wales. Registered number: 4181041. Registered office: Saxon House, Downside, Sunbury on Thames, Middlesex, TW16 6RT. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of DAN MUELLER Sent: 16 September 2016 12:53 To: ids@iiug.org Subject: Script for onstat to onspaces [37820] IDS 11.70.FC8XC4 AIX 6.1 Good Morning Folks, I have need to turn all my onstat -d output into onspaces commands. I found a couple of scripts in the repository but they either hang or fail. Does anyone have any reliable script for this that they would consider sharing? The end result is to take an AIX instance with about 500/1500 dbspaces/chunks and move it to an INTEL platform for performance testing. TIA, Dan ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.