Re: Viewing existing lock mode (fwd)
Run this SQL:
Select tabname,locklevel
from systables
where tabid > 99;locklevel - R is row, P is Page.
Defualt is PAGE if not specified when table is created
-------------------------------------------------------------------------
Cheryl Kendricks
Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov
DTSI, Inc.
Database Administrator - DOL Job Corps San Marcos, Texas
------------------------------------------------------------------------
On Wed, 24 Jul 1996 ANISHA_VASWANI@HP-SanJose-om1.om.hp.com wrote:
} Item Subject: Viewing existing lock mode
}
} Hi,
}
} I was also wrestling with the same problem below -- I'd like to know
} what granularity of locking is currently being used. We're running
} On-line version 7.12. Any help would be much appreciated.
}
} Thx
} Anisha
} anisha_vaswani@hp.com
}
}
} ______________________________ Reply Separator _________________________________
} Subject: Viewing existing lock mode
} Author: Non-HP-informix-list-owner (informix-list-owner@rmy.emory.edu) at
} HP-Boise,shargw4
} Date: 7/24/96 2:55 PM
}
}
} We are trying to find out if a table in the database has row, table or
} page locking. We are running with on-line version 5.02. Is there
} anyway we can look this up on the current database? Thanks for your
} help in advance.
}
} Wendy
} walm@icsware.com
}
}