Re: sysindexes: leaves and levels empty?
Hi!
I'm not sure what the leaves and levels columns contain, but I've written a
4GL utility to do the same thing by parsing the output from the tbcheck -pT
command. Let me know if you'd like a copy when I finish fine-tuning it.
The utility is long (>300 lines), so I won't post it to the group for fear
of clogging email channels. It's for OnLine 5.x, so you may require
recoding for it to work in 7.x. Also, I make use of sed, grep and awk UNIX
commands, so you'll be responsible for ensuring these commands produce the
output desired (I use Digital Unix 3.0b).
At 02:01 PM 9/8/97 EDT, you wrote:
}
}Hello!
}
}I'm playing around with the sysindexes table to write a 'recreate index'
utility.
}I tried
}---
}#!/usr/bin/ksh
}dbaccess << EOF
}database sysmaster
}select idxname, tabid, leaves, levels from sysindexes;
}EOF
}---
}but the columns for leaves and levels are always empty.
}
}I would like to get this information to calculate a
}value for starting or skipping a 'recreate index'.
}
}The printed documentation says nothing about these columns.
}(Informix Guide to SQL, V 7.2 : System Catalog)
}
}Thankx,
} Erik
}
}
}
}
}
}
}
}
}
Best regards,
Nigel
+-------------------------------------------------------------+
|Name : Edmund Nigel Gall Tel: (868) 636 3153 |
|Title : Information Systems Specialist Fax: (868) 679 3770 |
|Company: Process Plant Services Limited |
|Address: Atlantic Avenue, Point Lisas Industrial Estate |
| Point Lisas, Couva, Trinidad & Tobago, W.I. |
+----- mailto:nigelg@ppsl.com ------ http://www.ppsl.com -----+