Oninit cdi / Archive
Talk to an expert →

ontape -s using too much temp space

Posted in 2008

Topics: Backup & Restore, Installation, Setup & Upgrades, Storage & Space Management, Platform-Specific Issues

KEVIN STRUCKHOFF — — source: IIUG Forums & Mailing Lists

I'm running IDS 11.10.HC2 on an hp-ux 11i machine. We just upgraded from 9.40 3+ weeks ago. Previously, we had no problem running level 1 backups during the day. However, now I am noticing that my temp dbspace will sometimes fill up during the level 1 backup. I just aborted the backup and the temp dbspace usage went to essentially 0. here's a listing of what's in temp dbspace from oncheck -pe: DBspace Usage Report: tmpdbs Owner: informix Created: 10/26/1999 Chunk Pathname Size Used Free 33 /usr10/databases/tmpdbs.10_3 50000 50000 0 Description Offset(p) Size(p) ------------------------------------------------------------- -------- -------- RESERVED PAGES 0 2 CHUNK FREELIST PAGE 2 1 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 3 28480 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 28483 48 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 28531 320 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 28851 64 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 28915 320 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 29235 48 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 29283 640 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 29923 48 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 29971 320 I've never known temp dbspace to be used by ontape in this manner. Is this a new feature or? Thanks. Kevin Struckhoff IT Mgr GSI Commerce Inc.

↪ replying to KEVIN STRUCKHOFF
Jack Parker — — source: IIUG Forums & Mailing Lists

Point in time backups work by keeping track of all of your changes in temp while the dbspaces are backed up. These changes are then applied. Do less work while you are doing your backup, run your backup faster or create bigger temp spaces and this problem will go away. - Do less work - do the backups during off hours. - Run them faster - send them to disk - compressed files works nicely. - Add more temp dbspace. j. Sane ego te vocavi. Forsitan capedictum tuum desit. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of KEVIN STRUCKHOFF Sent: Tuesday, February 26, 2008 7:21 PM To: ids@iiug.org Subject: ontape -s using too much temp space [11443] I'm running IDS 11.10.HC2 on an hp-ux 11i machine. We just upgraded from 9.40 3+ weeks ago. Previously, we had no problem running level 1 backups during the day. However, now I am noticing that my temp dbspace will sometimes fill up during the level 1 backup. I just aborted the backup and the temp dbspace usage went to essentially 0. here's a listing of what's in temp dbspace from oncheck -pe: DBspace Usage Report: tmpdbs Owner: informix Created: 10/26/1999 Chunk Pathname Size Used Free 33 /usr10/databases/tmpdbs.10_3 50000 50000 0 Description Offset(p) Size(p) ------------------------------------------------------------- -------- -------- RESERVED PAGES 0 2 CHUNK FREELIST PAGE 2 1 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 3 28480 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 28483 48 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 28531 320 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 28851 64 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 28915 320 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 29235 48 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 29283 640 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 29923 48 (0x1b00003) BEFIMAGE:'root'.th_grp1all_00000001 29971 320 I've never known temp dbspace to be used by ontape in this manner. Is this a new feature or? Thanks. Kevin Struckhoff IT Mgr GSI Commerce Inc. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!

Glossary