Database reference - pubs3

Database overview

Documentation

Documentation generated on: 10/29/2008 10:30:44 PM

Database objects

typecount
tables14
views2
indexes14
procedures9
functions2
types2
triggers3
defaults3
rules3

Database properties

namevalue
namepubs3
serverSUMMER
size4.0 MB 
createdFeb 10, 2007
statustrunc log on chkpt, mixed log and data
ownersa
versionAdaptive Server Enterprise/15.0/EBF 12783 GA/P/NT (IX86)/Windows 2000/ase150/2158/32-bit/OPT/Fri Aug 19 18:42:50 2005

Server Properties

namevalue
Configuration Options0
General Information0
Backup/Recovery0
Cache Manager0
Disk I/O0
Languages0
Memory Use0
Network Communication0
O/S Resources0
Physical Resources0
Physical Memory0
Processors0
SQL Server Administration0
User Environment0
Lock Manager0
Security Related0
Meta-Data Caches0
Query Tuning0
Component Integration Services0
Extended Stored Procedure0
Error Log0
Rep Agent Thread Administratio0
Java Services0
DTM Administration0
Diagnostics0
Monitoring0
Unicode0
recovery interval in minutes5
allow updates to system tables0
number of user connections25
total logical memory29715
number of open databases12
number of locks5000
number of open objects500
default fill factor percent0
time slice100
default database size3
tape retention in days0
print recovery information0
configuration fileC:\sybase\S
allow nested triggers1
number of devices10
allow remote access1
number of remote logins20
number of remote sites10
number of remote connections20
remote server pre-read packets3
upgrade version15000
default sortorder id50
default language id0
max online engines1
number of engines at startup1
cpu accounting flush interval200
i/o accounting flush interval1000
default character set id2
total data cache size8774
disable character set conversi0
stack size41984
systemwide password expiration0
audit queue size100
additional network memory0
default network packet size2048
max network packet size2048
disable disk mirroring1
identity burning set factor5000
size of auto identity column10
identity grab size1
page lock promotion HWM200
procedure cache size7000
number of oam trips0
number of index trips0
allow sql server async i/o1
disk i/o structures256
executable codesize + overhead10742
max number network listeners5
tcp no delay1
o/s file descriptors100000
max async i/os per engine2147483647
max async i/os per server2147483647
lock shared memory0
allow sendmsg0
syb_sendmsg port number0
print deadlock information0
number of mailboxes30
number of messages64
number of alarms40
number of pre-allocated extent2
event buffers per engine100
sql server clock tick length100000
runnable process search count2000
i/o polling process count10
deadlock retries5
cpu grace time500
number of sort buffers500
txn to pss ratio16
permission cache entries15
stack guard size16384
memory alignment boundary2048
partition spinlock ratio10
partition groups1024
housekeeper free write percent1
page utilization percent95
user log cache size2048
user log cache spinlock ratio20
deadlock checking period500
lock address spinlock ratio100
lock table spinlock ratio20
page lock promotion LWM200
page lock promotion PCT100
curread change w/ open cursors1
shared memory starting address0
select on syscomments.text1
auditing0
current audit table1
suspend audit when device full1
open object spinlock ratio100
number of open indexes500
open index hash spinlock ratio100
open index spinlock ratio100
number of aux scan descriptors256
number of worker processes0
memory per worker process1024
max parallel degree1
max scan parallel degree1
allow resource limits0
allow procedure grouping1
dump on conditions0
cis connect timeout0
cis bulk insert batch size0
max cis remote connections0
cis packet size512
cis cursor rows50
enable snmp0
enable file access0
cis bulk insert array size50
enable full-text search0
cis rpc handling0
enable cis1
esp execution priority8
esp execution stacksize65536
xp_cmdshell context1
start mail session0
event logging1
log audit logon success0
log audit logon failure0
event log computer nameLocalSystem
esp unload dll0
SQL Perfmon Integration1
number of large i/o buffers6
max SQL text monitored0
global async prefetch limit10
unified login required0
use security services0
msg confidentiality reqd0
msg integrity reqd0
secure default loginguest
enable rep agent threads0
maximum dump conditions10
allow backward scans1
enable unicode conversions1
enable housekeeper GC1
row lock promotion HWM200
row lock promotion LWM200
row lock promotion PCT100
lock hashtable size2048
lock schemeallpages
lock spinlock ratio85
default exp_row_size percent5
lock wait period2147483647
size of unilib cache0
license information0
read committed with lock0
global cache partition number1
enable java1
size of process object heap1500
size of shared class heap1536
check password for digit0
minimum password length6
maximum failed logins0
enable xact coordination1
xact coordination interval60
number of dtx participants500
strict dtm enforcement0
dtm lock timeout period300
enable sort-merge join and JTC0
number of ccbs0
caps per ccb50
average cap size200
size of global fixed heap150
enable monitoring0
sql text pipe active0
sql text pipe max messages0
plan text pipe active0
plan text pipe max messages0
statement pipe active0
statement pipe max messages0
errorlog pipe active0
errorlog pipe max messages0
deadlock pipe active0
deadlock pipe max messages0
wait event timing0
process wait events0
object lockwait timing0
SQL batch capture0
statement statistics active0
enable HA0
text prefetch size16
enable DTM0
dtm detach timeout period0
abstract plan load0
abstract plan dump0
abstract plan replace0
abstract plan cache0
per object statistics active0
default unicode sortorderbinary
enable unicode normalization1
enable surrogate processing1
enable enterprise java beans0
enable ssl0
number of java sockets0
max memory39936
allocate max shared memory0
dynamic allocation on demand1
heap memory per user4096
enable row level access0
total physical memory29708
number of open partitions500
number of histogram steps20
sampling percent0
performance monitoring option0
i/o batch size100
statement cache size0
max concurrently recovered db0
number of checkpoint tasks1
send doneinproc tokens1
enable ldap user auth0
enable xml0
enable webservices0
enable job scheduler0
job scheduler tasks32
job scheduler interval1
percent database for history20
percent history free30
percent database for output30
percent output free50
maximum job output32768
enable real time messaging0
messaging memory400
extended cache size0
enable pam user auth0
histogram tuning factor1
number of dump threads1
max resource granularity10
optimization timeout limit10
max repartition degree1
optimization goalallrows_mix
enable metrics capture0
max native threads per engine50
rtm thread idle wait period600
sysstatistics flush interval0
enable semantic partitioning0
default xml sortorderbinary

Server attributes

namevalue
DBMS_NAMESQL Server
DBMS_VERSQL Server/12.5/P/Generic/OS/1/OPT/Sat Jun 30 00:01:37 PDT 2001
DBE_NAME
OWNER_TERMowner
TABLE_TERMtable
MAX_OWNER_NAME_LENGTH30
IDENTIFIER_CASEMIXED
COLUMN_LENGTH30
TABLE_LENGTH30
USERID_LENGTH30
TX_ISOLATION4
COLLATION_SEQ
MAX_QUAL_LENGTH30
QUALIFIER_TERMdatabase
SAVEPOINT_SUPPORTY
MULTI_RESULT_SETSY
NAMED_TRANSACTIONSY
SPROC_AS_LANGUAGEY
REMOTE_SPROCY
ACCESSIBLE_TABLESY
ACCESSIBLE_SPROCY
MAX_INDEX_COLS32
RENAME_TABLEY
RENAME_COLUMNY
DROP_COLUMNY
INCREASE_COLUMN_LENGTHN
DDL_IN_TRANSACTIONY
DESCENDING_INDEXESY
SP_RENAMEY
SYS_SPROC_VERSION01.01.2822



Documentation generated by SqlSpec