Oninit cdi / Archive
Talk to an expert →

Script to build dbspace from onstat -d output

Posted in 2008

Summary

A DBA on IDS 9.4 (Solaris 8) asked for a script that converts 'onstat -d' output into the onspaces commands needed to recreate an instance's dbspaces/chunks. Respondents pointed to existing tools on the IIUG site -- mk_spaces.sh and dup-spaces.sh -- noting they may need tweaking to handle smart blobs and non-default page sizes, and one poster attached his own create_onspaces script that generates onspaces commands from onstat -d. The original poster thanked everyone; no further detail on which script he used.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management, Server Administration, Platform-Specific Issues

Bruce Simms — — source: IIUG Forums & Mailing Lists

I was wondering if anyone has a script that will take the output from a onstat -d command and a output script of onspaces commands to build anew instance. Running Informix 9.4.FC9 OS- Solaris 8 Thanks for any information Bruce Simms Data Base Services TALX Corporation 2330 Ball Drive St. Louis, MO 63146 Phone (314) 214-7703 FAX (314) 983-3238 bsimms@talx.com

↪ replying to Bruce Simms
Paul Watson — — source: IIUG Forums & Mailing Lists

There is something on the IIUG website - can't remember the name but it works well BUT needs to be adjusted for smart blobs and diferent page sizes - not a big change Paul Watson Tel: +1 913-400-2620 Mob: +1 913-387-7529 Web: www.oninit.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. It is better to be criticized by a wise person than to be praised by a fool. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Bruce Simms Sent: Thursday, September 18, 2008 8:46 AM To: ids@iiug.org Subject: Script to build dbspace from onstat -d output [13418] I was wondering if anyone has a script that will take the output from a onstat -d command and a output script of onspaces commands to build anew instance. Running Informix 9.4.FC9 OS- Solaris 8 Thanks for any information Bruce Simms Data Base Services TALX Corporation 2330 Ball Drive St. Louis, MO 63146 Phone (314) 214-7703 FAX (314) 983-3238 bsimms@talx.com **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Paul Watson
Link, David A — — source: IIUG Forums & Mailing Lists

There was a mk_spaces.sh which we used. As Paul states, I don't think it handles some of the newer options. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Paul Watson Sent: Thursday, September 18, 2008 8:52 AM To: ids@iiug.org Subject: RE: Script to build dbspace from onstat -d output [13419] There is something on the IIUG website - can't remember the name but it works well BUT needs to be adjusted for smart blobs and diferent page sizes - not a big change Paul Watson Tel: +1 913-400-2620 Mob: +1 913-387-7529 Web: www.oninit.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. It is better to be criticized by a wise person than to be praised by a fool. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Bruce Simms Sent: Thursday, September 18, 2008 8:46 AM To: ids@iiug.org Subject: Script to build dbspace from onstat -d output [13418] I was wondering if anyone has a script that will take the output from a onstat -d command and a output script of onspaces commands to build anew instance. Running Informix 9.4.FC9 OS- Solaris 8 Thanks for any information Bruce Simms Data Base Services TALX Corporation 2330 Ball Drive St. Louis, MO 63146 Phone (314) 214-7703 FAX (314) 983-3238 bsimms@talx.com ************************************************************************ **** *** Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.169 / Virus Database: 270.6.21/1674 - Release Date: 9/17/2008 5:07 PM

↪ replying to Link, David A
Rajib Sarkar — — source: IIUG Forums & Mailing Lists

Long back I'd written something on the similar lines .. give it a try. = It creates the onspaces commands from the onstat -d output. (See attached file: create_onspaces.zip) Hopefully its still working .. :-) = Rajib Sarkar = SWG Client Support - Software = Sr. Technical Analyst = DB2 Advanced Problem Diagnostics Team ( Level 3 = Support) = rsarkar@us.ibm.com = = |------------> | From: | |------------> >--------------------------------------------------------------------= -----------------------------------------------------------------------= ------| |"Link, David A" <DALink@west.com> = = | >--------------------------------------------------------------------= -----------------------------------------------------------------------= ------| |------------> | To: | |------------> >--------------------------------------------------------------------= -----------------------------------------------------------------------= ------| |ids@iiug.org = = | >--------------------------------------------------------------------= -----------------------------------------------------------------------= ------| |------------> | Date: | |------------> >--------------------------------------------------------------------= -----------------------------------------------------------------------= ------| |09/18/2008 07:25 AM = = | >--------------------------------------------------------------------= -----------------------------------------------------------------------= ------| |------------> | Subject: | |------------> >--------------------------------------------------------------------= -----------------------------------------------------------------------= ------| |RE: Script to build dbspace from onstat -d output [13420] = = | >--------------------------------------------------------------------= -----------------------------------------------------------------------= ------| There was a mk_spaces.sh which we used. As Paul states, I don't think i= t handles some of the newer options. -----Original Message----- From: ids-bounces@iiug.org [?mailto:ids-bounces@iiug.org] On Behalf Of Paul Watson Sent: Thursday, September 18, 2008 8:52 AM To: ids@iiug.org Subject: RE: Script to build dbspace from onstat -d output [13419] There is something on the IIUG website - can't remember the name but it= works well BUT needs to be adjusted for smart blobs and diferent page sizes - not a big change Paul Watson Tel: +1 913-400-2620 Mob: +1 913-387-7529 Web: www.oninit.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. It is better to be criticized by a wise person than to be praised by a fool. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Bruce Simms Sent: Thursday, September 18, 2008 8:46 AM To: ids@iiug.org Subject: Script to build dbspace from onstat -d output [13418] I was wondering if anyone has a script that will take the output from a= onstat -d command and a output script of onspaces commands to build anew instance. Running Informix 9.4.FC9 OS- Solaris 8 Thanks for any information Bruce Simms Data Base Services TALX Corporation 2330 Ball Drive St. Louis, MO 63146 Phone (314) 214-7703 FAX (314) 983-3238 bsimms@talx.com ***********************************************************************= * **** *** Forum Note: Use "Reply" to post a response in the discussion forum. ***********************************************************************= * ******* Forum Note: Use "Reply" to post a response in the discussion forum. No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.169 / Virus Database: 270.6.21/1674 - Release Date: 9/17/2008 5:07 PM ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

↪ replying to Rajib Sarkar
PANKAJ PATEL — — source: IIUG Forums & Mailing Lists

there is dup-spaces.sh that does what you want.

↪ replying to PANKAJ PATEL
Bruce Simms — — source: IIUG Forums & Mailing Lists

A big Thanks to all who have given suggestions. Bruce Simms Data Base Services TALX Corporation 2330 Ball Drive St. Louis, MO 63146 Phone (314) 214-7703 FAX (314) 983-3238 bsimms@talx.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of PANKAJ PATEL Sent: Thursday, September 18, 2008 11:29 AM To: ids@iiug.org Subject: Re: RE: Script to build dbspace from onstat -d.... [13423] there is dup-spaces.sh that does what you want. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Related threads

Glossary