Error 9965 Severity 20 State 1
Contents |
visit, be sure to check out the FAQ by clicking the link above. You may have to register before dbcc error 9965 you can post: click the register link above to proceed.
Error 9003 Severity 20 State 1
To start viewing messages, select the forum that you want to visit from the selection below.
Error 7884 Severity 20 State 1
Results 1 to 2 of 2 Thread: DBCC config - parameters missing/insufficient Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search
Error 7886 Severity 20 State 1
Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-25-13,09:59 #1 Martijnvs View Profile View Forum Posts Registered User Join Date Jan 2004 Posts 545 Provided Answers: 4 Unanswered: DBCC config - parameters missing/insufficient I am in the process of configuring a brand new ASE15.5 instance. So far, so good, but the dbccdb-config won't work. The following steps were taken: Code: Recommended size for dbccdb database is 125MB (data = 123MB, log = 2MB). dbccdb database already exists with size 1500MB. Recommended values for workspace size, cache size and process count are: dbname scan ws text ws cache comp mem process count master 3696K 928K 925K 0K 1 tempdb 6208K 1568K 1556K 0K 2 model 64K 48K 640K 0K 1 sybsystemdb 1280K 336K 1280K 0K 2 sybsystemprocs 2464K 624K 640K 0K 1 dbccdb 18448K 4624K 4615K 0K 2 The dbccdb was the first db to be configured: Code: use dbccdb go sp_addsegment scanseg, dbccdb, dbccdb_data_01 go sp_addsegment textseg, dbccdb, dbccdb_data_01 go -- sp_dbcc_createws dbccdb, scanseg, scan_dbccdb, scan, '20000K' go sp_dbcc_createws dbccdb, textseg, text_dbccdb, text, '5000K' go sp_dbcc_updateconfig dbccdb, 'max worker processes', '2' go sp_dbcc_updateconfig dbccdb, 'scan workspace', 'scan_dbccdb' go sp_dbcc_updateconfig dbccdb, 'text workspace', 'text_dbccdb' go sp_dbcc_updateconfig dbccdb, 'dbcc named cache', 'default data cache', '6M' go To check - doublecheck I ra
to @@data_high can perform the DBCC command `%.*s'. Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command. 9902 14 Only users with SA and SSO roles can run this dbcc dbrepair command for the database %S_DBID. Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command. 9903 14 Only users with SA and SSO roles having their http://www.dbforums.com/showthread.php?1696791-DBCC-config-parameters-missing-insufficient curread dominating the maxhold of the database can run this dbcc dbrepair command for the database `%S_DBID'. Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command. 9904 10 Total (# of text chains = %ld text pages = %ld) in this table. Explanation: This is an http://infocenter-archive.sybase.com/help/topic/com.sybase.39996_1250/html/svrtsg/svrtsg366.htm informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 9905 10 Processed %ld tables. Found %ld good text entries, %ld bad text entries in this database Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 9906 16 Unrecognized option. Available options: dbcc engine(net, show, engine#), dbcc engine(net, showall), dbcc engine(net, netengine) Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 9908 16 Syspartitions system table does not exist in database id %S_DBID. Explanation: Adaptive Server could not perform the requested action. Modify your command to meet the Adaptive Server requirement for the objects or variables shown in the error message. 9909 10 The total number of data pages in partition %d is %d. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 9911 10 Object %ld has one row in S
publisher? Claim or contact us about this channel Embed this content in your HTML Search confirm cancel Report adult content: click to rate: Account: (login) More Channels Showcase RSS Channel Showcase http://sybase69.rssing.com/chan-12538163/all_p10.html 4054461 RSS Channel Showcase 7189486 RSS Channel Showcase 7267646 RSS Channel Showcase 5752283 Channel Catalog Subsection Catalog Articles on this Page (showing articles 181 to 200 of 3587) 08/05/13--08:25: _dump load 'cross-pl... http://www.ncbi.nlm.nih.gov/pmc/articles/PMC4709232/ 08/06/13--22:52: _Re: dbcc checkstora... 08/07/13--03:02: _Re: dump load 'cros... 08/07/13--03:45: _Re: dump load 'cros... 08/07/13--18:54: _Re: dump load 'cros... 08/08/13--07:07: _Re: dump load 'cros... 08/08/13--07:58: _Re: dbcc checkstora... 08/08/13--18:21: _Re: dbcc checkstora... 08/10/13--02:23: severity 20 _UNMOUNT DATABASE co... 08/10/13--03:49: _ASE - Storage on bi... 08/11/13--10:10: _Re: UNMOUNT DATABAS... 08/11/13--10:18: _Re: ASE - Storage o... 08/11/13--10:55: _Re: Stored procedur... 08/11/13--19:24: _Re: UNMOUNT DATABAS... 08/12/13--06:03: _Re: UNMOUNT DATABAS... 08/12/13--09:21: _Re: UNMOUNT DATABAS... 08/12/13--09:12: _Re: Stored procedur... 08/12/13--08:22: _Re: UNMOUNT DATABAS... 08/13/13--12:36: _Re: What exactly is... 08/13/13--12:50: _Re: What exactly is... (showing articles 181 to 200 of 3587) Browse the Latest Snapshot Browsing All severity 20 state Articles (3587 Articles) Live Browser Channel Description: Most recent forum messages older | 1 | .... | 7 | 8 | 9 | (Page 10) | 11 | 12 | 13 | .... | 180 | newer 0 0 08/05/13--08:25: dump load 'cross-platform' - How to know if sp_flushstats was executed? Contact us about this article Thanks all for you feedback, I'll continue including in my ETA additional time to do the conversion part then. Thanks Simon 0 0 08/06/13--22:52: Re: dbcc checkstorage inside rpc Contact us about this article Thanks. At least the rpc works for me. So can't recreate the issue that you are getting. Two suggestions: 1. Can you check the output of sp_plan_dbcc 'pubs2' and see everything is aligned properly? From your comments it looks that dbcc checkstorage works for you without rpc. 2. Try the sp_rpc_setup_check from the same Rob Verschoor location fto make sure the rpc requirements are aligned properly, although I admit that does not look like the issue. Notes: I am working with sysadmin privs and on Sybase ASE 15.7 ESD 4 , so not on same version as yours. war
Health Search databasePMCAll DatabasesAssemblyBioProjectBioSampleBioSystemsBooksClinVarCloneConserved DomainsdbGaPdbVarESTGeneGenomeGEO DataSetsGEO ProfilesGSSGTRHomoloGeneMedGenMeSHNCBI Web SiteNLM CatalogNucleotideOMIMPMCPopSetProbeProteinProtein ClustersPubChem BioAssayPubChem CompoundPubChem SubstancePubMedPubMed HealthSNPSRAStructureTaxonomyToolKitToolKitAllToolKitBookToolKitBookghUniGeneSearch termSearch Advanced Journal list Help Journal ListPLoS Onev.11(1); 2016PMC4709232 PLoS One. 2016; 11(1): e0146723. Published online 2016 Jan 11. doi: 10.1371/journal.pone.0146723PMCID: PMC4709232Race, Ethnicity, Psychosocial Factors, and Telomere Length in a Multicenter SettingShannon M Lynch,#1,2,* M. K. Peek,#3 Nandita Mitra,1 Krithika Ravichandran,4 Charles Branas,1 Elaine Spangler,1 Wenting Zhou,1 Electra D. Paskett,5 Sarah Gehlert,6 Cecilia DeGraffinreid,5 Timothy R. Rebbeck,#1,7 and Harold Riethman#3,8Kazuya Iwamoto, Editor1University of Pennsylvania, Philadelphia, PA, United States of America2Fox Chase Cancer Center, Philadelphia, PA, United States of America3University of Texas Medical Branch, Galveston, TX, United States of America4Wistar Institute, Philadelphia, PA, United States of America5The Ohio State University, Columbus, OH, United States of America6Washington University, St. Louis, MO, United States of America7Dana Farber Cancer Institute and Harvard University, Boston, MA, United States of America8Old Dominion University, Norfolk, VA, United States of AmericaUniversity of Tokyo, JAPAN#Contributed equally. Competing Interests: The authors have declared that no competing interests exist.Conceived and designed the experiments: SML MKP TRR HR SG EDP NM CB. Performed the experiments: SML MKP HR CD WZ ES KR. Analyzed the data: SML KR. Contributed reagents/materials/analysis tools: MKP TRR SG EDP HR SML WZ ES. Wrote the paper: SML MKP TRR HR NM CB SG EK.* E-mail: ude.cccf@hcnyl.nonnahsAuthor information ► Article notes ► Copyright and License information ►Received 2015 May 20; Accepted 2015 Dec 20.Copyright © 2016 Lynch et alThis is an open access article distributed under the terms of the Creative Commons Attribution License, which permits unrestricted us