vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi DB2 users, I am using DB2 UDB V6 on z/OS, the only way that i know for get the lenght of a index is summarize every column length getting this information joining the SYSIBM.SYSKEYS and the SYSIBM.SYSCOLUMNS....someone know a faster and maybe more direct system for get this informations from DB2? About reorg online i must define manually the shadow datasets because if i don't do it, DB2 define the shadow ds on the same volume which sometime have not enough space...can it depend from SMS settings? Luca |