cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

sybase logs

Go to solution
Former Member

on ‎12-03-2013 9:24 AM

0 Kudos

Hi all,

       I had deleted historical logs and data from in dbacockpit using prune data and prune log.

       after that i restarted the system.

       now when i try to connect to dbacockpit it says "sybase ase error 4001 cannot open default database saptools".

       I am new to sybase. can any one tell me were we can find the logs related to this and database error logs.

  thank you very much for your time

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎01-09-2014 10:40 AM
0 Kudos

Hi thomus,

              yes you can change the status with sp_resetstatus.

             but keep in mind, once the status has been changed, do not restart the whole server, but just the database that you want to using "dbcc bdreboot" command.

Show replies
Show replies

Answers (6)

Answers (6)

Former Member
‎01-03-2014 11:39 AM
0 Kudos

HI

   thanks kimon,

   I had arleady tried what you have suggested.

  but the problem is the saptools database is shutdown. and when i try to extend. it says the same thing " saptools database is already shutdown"

and it is marked suspect.

i can change the status of that with sp_resetstatus. but i am not sure about that. ( as how system would respond after changing the status)

as in the sybase site it says " this method is not suggested.

regards

thomus

Show replies
Show replies
kimon_moschandreou
Contributor
‎01-03-2014 11:48 AM
0 Kudos

Hi,

Please send me

select name,status,status2,status3,status4 from sysdatabases where name='saptools'

Regards,

Kimon

kimon_moschandreou
Contributor
‎01-03-2014 12:08 PM
0 Kudos

Hi,

If I were you I should run sp_resetstatus or the the SQL alternative (probably the second).

Also just now I noticed that the log extract is old, maybe a latest extract from the last reboot will show us why the database is suspect. Maybe the disk space issue is not the reason

Regards,

Kimon

Former Member
‎01-03-2014 10:47 AM
0 Kudos

hI,

   the saptools database has shutdown because of the low disk space.

  here is the sybase/SID/ASE/install/<SID>.log

00:0000:00000:00000:2013/11/19 17:57:06.77 kernel  SySAM: Using licenses from: /sybase/VED/SYSAM-2_0/licenses/SYBASE.lic:/sybase/VED/SYSAM-2_0/licenses/SYBASE_ASE_DE.lic

00:0000:00000:00000:2013/11/19 17:57:06.78 kernel  SySAM: Checked out license for 8 ASE_CORE (2013.1231/permanent/0AA8 42CE 5872 3BD7).

00:0000:00000:00000:2013/11/19 17:57:06.78 kernel  This product is licensed to: SAP, for use with SAP Business Applications.

00:0000:00000:00000:2013/11/19 17:57:06.78 kernel  Checked out license ASE_CORE

00:0000:00000:00000:2013/11/19 17:57:06.78 kernel  Adaptive Server Enterprise (Enterprise Edition)

00:0000:00000:00000:2013/11/19 17:57:06.79 kernel  Using config area from primary master device.

00:0000:00000:00000:2013/11/19 17:57:06.81 kernel  SySAM: Checked out license for 8 ASE_PARTITIONS (2013.1231/permanent/0AA8 42CE 5872 3BD7).

00:0000:00000:00000:2013/11/19 17:57:06.81 kernel  Checked out license ASE_PARTITIONS

00:0000:00000:00000:2013/11/19 17:57:06.82 kernel  SySAM: Checked out license for 8 ASE_COMPRESSION (2013.1231/permanent/0AA8 42CE 5872 3BD7).

00:0000:00000:00000:2013/11/19 17:57:06.82 kernel  Checked out license ASE_COMPRESSION

00:0000:00000:00000:2013/11/19 17:57:06.82 kernel  SySAM: Checked out license for 8 ASE_ASM (2013.1231/permanent/0AA8 42CE 5872 3BD7).

00:0000:00000:00000:2013/11/19 17:57:06.82 kernel  Checked out license ASE_ASM

00:0000:00000:00000:2013/11/19 17:57:06.82 kernel  Kernel memory at 0x0000000160000000, 2621440000 bytes

00:0000:00000:00000:2013/11/19 17:57:06.82 kernel  Adaptive Server is using the threaded kernel mode.

00:0000:00000:00000:2013/11/19 17:57:06.82 kernel  Using 65534 file descriptors.

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  Adaptive Server Enterprise/15.7.0/EBF 20729 SMP ESD#03 /P/RS6000/AIX 6.1/ase157esd3/3183/64-bit/FBO/Sat Dec  8 16:19:51 2012

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  Confidential property of Sybase, Inc.

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  Copyright 1987, 2012

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  Sybase, Inc.  All rights reserved.

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  Unpublished rights reserved under U.S. copyright laws.

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel 

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  This software contains confidential and trade secret information of Sybase,

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  agreement  specifying  the  Government's rights to use the software and any

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  applicable FAR provisions, for example, FAR 52.227-19.

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  Using /sybase/VED as the 'SYBASE' environment variable, found during startup.

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  Using OCS-15_0 as the 'SYBASE_OCS' environment variable, found during startup.

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  Using ASE-15_0 as the 'SYBASE_ASE' environment variable, found during startup.

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  ASE booted on host 'vemeccdev' running AIX release 1 version 7.

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  Using '/sybase/VED/ASE-15_0/VED.cfg' for configuration information.

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  Logging ASE messages in file '/sybase/VED/ASE-15_0/install/VED.log'.

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  Disk Controller Manager is online.

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  Network Controller Manager is online.

00:0000:00000:00000:2013/11/19 17:57:06.83 kernel  Ct-Lib Controller Manager is online.

00:0000:00000:00000:2013/11/19 17:57:06.84 kernel  Platform TCP network support seems IPv6-aware, IPv4/IPv6 are both enabled.

00:0000:00000:00000:2013/11/19 17:57:06.84 kernel  ASE booted with TCP_NODELAY enabled.

00:0000:00000:00000:2013/11/19 17:57:06.84 kernel  Network and device connection limit is 65519.

00:0000:00000:00000:2013/11/19 17:57:06.84 kernel  ASE - Dynamic Pluggable Component Interface is disabled

00:0000:00000:00000:2013/11/19 17:57:06.84 kernel  Adaptive Server is running as process id 6291656.

00:0000:00000:00000:2013/11/19 17:57:08.11 server  Number of blocks left for proc headers: 313248.

00:0000:00000:00000:2013/11/19 17:57:08.11 server  Proc header memory allocated 3915 pages for each per engine cache

00:0000:00000:00000:2013/11/19 17:57:08.12 server  Proc header memory allocated 3915 pages for engine 0 local cache

00:0000:00000:00000:2013/11/19 17:57:08.12 kernel  Create Thread Pool 2, "syb_system_pool", type="Run To Completion", with 1 threads

00:0000:00000:00000:2013/11/19 17:57:08.12 kernel  Create Thread Pool 1, "syb_default_pool", type="Engine (Multiplexed)", with 16 threads

00:0000:00000:00000:2013/11/19 17:57:08.13 server  Proc header memory allocated 3915 pages for engine 1 local cache

00:0000:00000:00000:2013/11/19 17:57:08.14 server  Proc header memory allocated 3915 pages for engine 2 local cache

00:0000:00000:00000:2013/11/19 17:57:08.16 server  Proc header memory allocated 3915 pages for engine 3 local cache

00:0000:00000:00000:2013/11/19 17:57:08.17 server  Proc header memory allocated 3915 pages for engine 4 local cache

00:0000:00000:00000:2013/11/19 17:57:08.18 server  Proc header memory allocated 3915 pages for engine 5 local cache

00:0000:00000:00000:2013/11/19 17:57:08.19 server  Proc header memory allocated 3915 pages for engine 6 local cache

00:0000:00000:00000:2013/11/19 17:57:08.20 server  Proc header memory allocated 3915 pages for engine 7 local cache

00:0000:00000:00000:2013/11/19 17:57:08.21 server  Proc header memory allocated 3915 pages for engine 8 local cache

00:0000:00000:00000:2013/11/19 17:57:08.23 server  Proc header memory allocated 3915 pages for engine 9 local cache

00:0000:00000:00000:2013/11/19 17:57:08.24 server  Proc header memory allocated 3915 pages for engine 10 local cache

00:0000:00000:00000:2013/11/19 17:57:08.25 server  Proc header memory allocated 3915 pages for engine 11 local cache

00:0000:00000:00000:2013/11/19 17:57:08.26 server  Proc header memory allocated 3915 pages for engine 12 local cache

00:0000:00000:00000:2013/11/19 17:57:08.27 server  Proc header memory allocated 3915 pages for engine 13 local cache

00:0000:00000:00000:2013/11/19 17:57:08.28 server  Proc header memory allocated 3915 pages for engine 14 local cache

00:0000:00000:00000:2013/11/19 17:57:08.30 server  Proc header memory allocated 3915 pages for engine 15 local cache

00:0000:00000:00000:2013/11/19 17:57:08.30 kernel  Create Thread Pool 3, "syb_blocking_pool", type="Run To Completion", with 4 threads

00:0022:00000:00000:2013/11/19 17:57:08.42 kernel  I/O controller 2 (NetController) is running as task 1617310400 on thread 22 (LWP 56557717).

00:0023:00000:00000:2013/11/19 17:57:08.42 kernel  I/O controller 3 (DiskController) is running as task 1617312080 on thread 23 (LWP 57147637).

00:0000:00000:00000:2013/11/19 17:57:08.42 kernel  Initializing virtual device 0, '/sybase/VED/sybsystem/master.dat' with dsync 'off'.

00:0000:00000:00000:2013/11/19 17:57:08.42 kernel  Virtual device 0 started using asynchronous (with DIRECTIO) i/o.

00:0000:00000:00000:2013/11/19 17:57:08.42 server  Loaded default Unilib conversion handle.

00:0000:00000:00000:2013/11/19 17:57:08.42 kernel  Worker Thread Manager is not enabled for use in ASE.

00:0000:00000:00000:2013/11/19 17:57:08.42 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.

00:0000:00000:00000:2013/11/19 17:57:08.44 kernel  libsybibmmq - Sybase IBM MQ interface/15.7.0/EBF 20729 SMP ESD#03 /P/RS6000/AIX 6.1/ase157esd3/3183/64-bit/OPT/Sat Dec  8 15:25:29 2012

00:0000:00000:00000:2013/11/19 17:57:08.45 kernel  Loaded encryption provider CSI-2.7M3-ibmaix64-2012/07/24 06:41:58 PDT-sybcsi_certicom_fips-Certicom Security Builder SSL-C V5.2.2r.

00:0000:00000:00000:2013/11/19 17:57:08.45 kernel  Begin processing to generate RSA keypair.

00:0000:00000:00000:2013/11/19 17:57:08.50 kernel  Completed processing to generate RSA keypair.

00:0000:00000:00000:2013/11/19 17:57:08.50 kernel  Begin processing to generate RSA keypair.

00:0000:00000:00000:2013/11/19 17:57:08.61 kernel  Completed processing to generate RSA keypair.

00:0000:00000:00000:2013/11/19 17:57:08.61 kernel  Encryption provider initialization succeeded on engine 0.

00:0000:00000:00000:2013/11/19 17:57:08.61 kernel  SSL Plus v5.2.2 security modules loaded successfully.

00:0002:00000:00000:2013/11/19 17:57:08.61 kernel  Network and device connection limit is 65519.

00:0002:00000:00000:2013/11/19 17:57:08.61 kernel  ASE - Dynamic Pluggable Component Interface is disabled

00:0002:00000:00000:2013/11/19 17:57:08.61 kernel  Thread 2 (LWP 47120563) of Threadpool syb_default_pool online as engine 0

00:0002:00000:00000:2013/11/19 17:57:08.61 server  No active traceflags

00:0002:00000:00001:2013/11/19 17:57:08.61 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/15.7/P-EBF20562 ESD #4 ONE-OFF/DRV.15.7.0.4/RS6000/AIX 6.1 Native Threads/BUILD1570-021/64bit/OPT/Thu Sep 13 07:47:43 2012'

00:0002:00000:00001:2013/11/19 17:57:08.61 server  Size of the 16K memory pool: 51200 Kb

00:0002:00000:00001:2013/11/19 17:57:08.61 server  Size of the 16K memory pool: 51200 Kb

00:0002:00000:00001:2013/11/19 17:57:08.61 server  Size of the 16K memory pool: 51200 Kb

00:0002:00000:00001:2013/11/19 17:57:08.62 server  Size of the 16K memory pool: 51200 Kb

00:0002:00000:00001:2013/11/19 17:57:08.62 server  Size of the 16K memory pool: 51200 Kb

00:0002:00000:00001:2013/11/19 17:57:08.62 server  Size of the 16K memory pool: 51200 Kb

00:0002:00000:00001:2013/11/19 17:57:08.62 server  Size of the 16K memory pool: 51200 Kb

00:0002:00000:00001:2013/11/19 17:57:08.62 server  Size of the 16K memory pool: 51200 Kb

00:0002:00000:00001:2013/11/19 17:57:08.62 server  Opening Master Database ...

00:0002:00000:00001:2013/11/19 17:57:08.69 server  Loading ASE's default sort order and character set

00:0002:00000:00001:2013/11/19 17:57:08.72 server  Recovering database 'master'.

00:0002:00000:00001:2013/11/19 17:57:08.72 server  Started estimating recovery log boundaries for database 'master'.

00:0002:00000:00001:2013/11/19 17:57:08.72 server  Database 'master', checkpoint=(4454, 94), first=(4454, 94), last=(4454, 94).

00:0002:00000:00001:2013/11/19 17:57:08.72 server  Completed estimating recovery log boundaries for database 'master'.

00:0002:00000:00001:2013/11/19 17:57:08.72 server  Started ANALYSIS pass for database 'master'.

00:0002:00000:00001:2013/11/19 17:57:08.72 server  Completed ANALYSIS pass for database 'master'.

00:0002:00000:00001:2013/11/19 17:57:08.72 server  Log contains all committed transactions until 2013/11/19 17:56:17.55 for database master.

00:0002:00000:00001:2013/11/19 17:57:08.72 server  Started REDO pass for database 'master'. The total number of log records to process is 1.

00:0002:00000:00001:2013/11/19 17:57:08.72 server  Completed REDO pass for database 'master'.

00:0002:00000:00001:2013/11/19 17:57:08.95 server  Timestamp for database 'master' is (0x0000, 0x000334d0).

00:0002:00000:00001:2013/11/19 17:57:08.95 server  Recovery of database 'master' will undo incomplete nested top actions.

00:0002:00000:00001:2013/11/19 17:57:08.95 server  Started recovery checkpoint for database 'master'.

00:0002:00000:00001:2013/11/19 17:57:08.96 server  Completed recovery checkpoint for database 'master'.

00:0002:00000:00001:2013/11/19 17:57:08.96 server  Started filling free space info for database 'master'.

00:0002:00000:00001:2013/11/19 17:57:08.96 server  Completed filling free space info for database 'master'.

00:0002:00000:00001:2013/11/19 17:57:08.96 server  Started cleaning up the default data cache for database 'master'.

00:0002:00000:00001:2013/11/19 17:57:08.96 server  Completed cleaning up the default data cache for database 'master'.

00:0002:00000:00001:2013/11/19 17:57:08.97 server  Checking external objects.

00:0002:00000:00001:2013/11/19 17:57:09.05 server  Database 'master' is now online.

00:0002:00000:00001:2013/11/19 17:57:09.06 server  The transaction log in the database 'master' will use I/O size of 16 Kb.

00:0002:00000:00001:2013/11/19 17:57:09.12 server  server name is 'VED'

00:0002:00000:00001:2013/11/19 17:57:09.43 server  Activating disk 'sysprocsdev' of size 204800 KB.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Initializing virtual device 1, '/sybase/VED/sybsystem/sysprocs.dat' with dsync 'off'.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Virtual device 1 started using asynchronous (with DIRECTIO) i/o.

00:0002:00000:00001:2013/11/19 17:57:09.43 server  Activating disk 'systemdbdev' of size 24576 KB.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Initializing virtual device 2, '/sybase/VED/sybsystem/sybsysdb.dat' with dsync 'off'.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Virtual device 2 started using asynchronous (with DIRECTIO) i/o.

00:0002:00000:00001:2013/11/19 17:57:09.43 server  Activating disk 'tempdbdev' of size 2097152 KB.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Initializing virtual device 3, '/sybase/VED/sybtemp/tempdbdev.dat' with dsync 'off'.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Virtual device 3 started using asynchronous i/o.

00:0002:00000:00001:2013/11/19 17:57:09.43 server  Activating disk 'sybmgmtdev' of size 76800 KB.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Initializing virtual device 4, '/sybase/VED/sybsystem/sybmgmtdb.dat' with dsync 'off'.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Virtual device 4 started using asynchronous (with DIRECTIO) i/o.

00:0002:00000:00001:2013/11/19 17:57:09.43 server  Activating disk 'dataVED_1' of size 154943488 KB.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Initializing virtual device 5, '/sybase/VED/sapdata_1/dataVED_1.dat' with dsync 'off'.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Virtual device 5 started using asynchronous (with DIRECTIO) i/o.

00:0002:00000:00001:2013/11/19 17:57:09.43 server  Activating disk 'logVED_1' of size 52305920 KB.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Initializing virtual device 6, '/sybase/VED/saplog_1/logVED_1.dat' with dsync 'off'.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Virtual device 6 started using asynchronous (with DIRECTIO) i/o.

00:0002:00000:00001:2013/11/19 17:57:09.43 server  Activating disk 'datasaptools_1' of size 2097152 KB.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Initializing virtual device 7, '/sybase/VED/sapdiag/datasaptools_1.dat' with dsync 'off'.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Virtual device 7 started using asynchronous (with DIRECTIO) i/o.

00:0002:00000:00001:2013/11/19 17:57:09.43 server  Activating disk 'logsaptools_1' of size 204800 KB.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Initializing virtual device 8, '/sybase/VED/sapdiag/logsaptools_1.dat' with dsync 'off'.

00:0002:00000:00001:2013/11/19 17:57:09.43 kernel  Virtual device 8 started using asynchronous (with DIRECTIO) i/o.

00:0002:00000:00001:2013/11/19 17:57:10.06 server  Recovering database 'sybsystemdb'.

00:0002:00000:00001:2013/11/19 17:57:10.06 server  Started estimating recovery log boundaries for database 'sybsystemdb'.

00:0002:00000:00001:2013/11/19 17:57:10.08 server  Database 'sybsystemdb', checkpoint=(907, 87), first=(907, 87), last=(907, 87).

00:0002:00000:00001:2013/11/19 17:57:10.08 server  Completed estimating recovery log boundaries for database 'sybsystemdb'.

00:0002:00000:00001:2013/11/19 17:57:10.08 server  Started ANALYSIS pass for database 'sybsystemdb'.

00:0002:00000:00001:2013/11/19 17:57:10.08 server  Completed ANALYSIS pass for database 'sybsystemdb'.

00:0002:00000:00001:2013/11/19 17:57:10.08 server  Log contains all committed transactions until 2013/01/09 12:03:23.19 for database sybsystemdb.

00:0002:00000:00001:2013/11/19 17:57:10.08 server  Started REDO pass for database 'sybsystemdb'. The total number of log records to process is 1.

00:0002:00000:00001:2013/11/19 17:57:10.08 server  Completed REDO pass for database 'sybsystemdb'.

00:0002:00000:00001:2013/11/19 17:57:10.13 server  Timestamp for database 'sybsystemdb' is (0x0000, 0x00001e13).

00:0002:00000:00001:2013/11/19 17:57:10.13 server  Recovery of database 'sybsystemdb' will undo incomplete nested top actions.

00:0002:00000:00001:2013/11/19 17:57:10.15 server  Started recovery checkpoint for database 'sybsystemdb'.

00:0002:00000:00001:2013/11/19 17:57:10.16 server  Completed recovery checkpoint for database 'sybsystemdb'.

00:0002:00000:00001:2013/11/19 17:57:10.16 server  Started filling free space info for database 'sybsystemdb'.

00:0002:00000:00001:2013/11/19 17:57:10.16 server  Completed filling free space info for database 'sybsystemdb'.

00:0002:00000:00001:2013/11/19 17:57:10.16 server  Started cleaning up the default data cache for database 'sybsystemdb'.

00:0002:00000:00001:2013/11/19 17:57:10.16 server  Completed cleaning up the default data cache for database 'sybsystemdb'.

00:0002:00000:00001:2013/11/19 17:57:10.16 server  Boot Count: 46

00:0002:00000:00001:2013/11/19 17:57:10.18 server  Checking external objects.

00:0002:00000:00001:2013/11/19 17:57:10.22 server  The transaction log in the database 'sybsystemdb' will use I/O size of 16 Kb.

00:0002:00000:00001:2013/11/19 17:57:10.22 server  Resident Node id: c87cae019fd7

00:0002:00000:00001:2013/11/19 17:57:10.22 server  Transaction coordinator initialized.

00:0002:00000:00001:2013/11/19 17:57:10.22 server  Database 'sybsystemdb' is now online.

00:0002:00000:00001:2013/11/19 17:57:10.25 server  Recovering database 'model'.

00:0002:00000:00001:2013/11/19 17:57:10.25 server  Started estimating recovery log boundaries for database 'model'.

00:0002:00000:00001:2013/11/19 17:57:10.26 server  Database 'model', checkpoint=(876, 151), first=(876, 151), last=(876, 151).

00:0002:00000:00001:2013/11/19 17:57:10.26 server  Completed estimating recovery log boundaries for database 'model'.

00:0002:00000:00001:2013/11/19 17:57:10.26 server  Started ANALYSIS pass for database 'model'.

00:0002:00000:00001:2013/11/19 17:57:10.26 server  Completed ANALYSIS pass for database 'model'.

00:0002:00000:00001:2013/11/19 17:57:10.26 server  Log contains all committed transactions until 2013/01/09 12:03:23.33 for database model.

00:0002:00000:00001:2013/11/19 17:57:10.26 server  Started REDO pass for database 'model'. The total number of log records to process is 1.

00:0002:00000:00001:2013/11/19 17:57:10.26 server  Completed REDO pass for database 'model'.

00:0002:00000:00001:2013/11/19 17:57:10.27 server  Timestamp for database 'model' is (0x0000, 0x00001f37).

00:0002:00000:00001:2013/11/19 17:57:10.27 server  Recovery of database 'model' will undo incomplete nested top actions.

00:0002:00000:00001:2013/11/19 17:57:10.27 server  Started recovery checkpoint for database 'model'.

00:0002:00000:00001:2013/11/19 17:57:10.27 server  Completed recovery checkpoint for database 'model'.

00:0002:00000:00001:2013/11/19 17:57:10.28 server  Started filling free space info for database 'model'.

00:0002:00000:00001:2013/11/19 17:57:10.28 server  Completed filling free space info for database 'model'.

00:0002:00000:00001:2013/11/19 17:57:10.28 server  Started cleaning up the default data cache for database 'model'.

00:0002:00000:00001:2013/11/19 17:57:10.28 server  Completed cleaning up the default data cache for database 'model'.

00:0002:00000:00001:2013/11/19 17:57:10.28 server  Checking external objects.

00:0002:00000:00001:2013/11/19 17:57:10.33 server  The transaction log in the database 'model' will use I/O size of 16 Kb.

00:0002:00000:00001:2013/11/19 17:57:10.33 server  Database 'model' is now online.

00:0002:00000:00001:2013/11/19 17:57:10.33 server  The logical pagesize of the server is 16 Kb.

00:0002:00000:00001:2013/11/19 17:57:10.33 server  0 dump conditions detected at boot time

00:0002:00000:00001:2013/11/19 17:57:10.33 server  Clearing temporary database 'tempdb'.

00:0002:00000:00001:2013/11/19 17:57:10.52 server  Processed 52 allocation unit(s) out of 518 units (allocation page 13056). 10% completed.

00:0002:00000:00001:2013/11/19 17:57:10.52 server  Processed 104 allocation unit(s) out of 518 units (allocation page 26368). 20% completed.

00:0002:00000:00001:2013/11/19 17:57:10.72 server  Processed 156 allocation unit(s) out of 518 units (allocation page 39680). 30% completed.

00:0002:00000:00001:2013/11/19 17:57:11.06 server  Processed 208 allocation unit(s) out of 518 units (allocation page 52992). 40% completed.

00:0002:00000:00001:2013/11/19 17:57:11.06 server  Processed 259 allocation unit(s) out of 518 units (allocation page 66048). 50% completed.

00:0002:00000:00001:2013/11/19 17:57:11.06 server  Processed 311 allocation unit(s) out of 518 units (allocation page 79360). 60% completed.

00:0002:00000:00001:2013/11/19 17:57:11.06 server  Processed 363 allocation unit(s) out of 518 units (allocation page 92672). 70% completed.

00:0002:00000:00001:2013/11/19 17:57:11.07 server  Processed 415 allocation unit(s) out of 518 units (allocation page 105984). 80% completed.

00:0002:00000:00001:2013/11/19 17:57:11.07 server  Processed 467 allocation unit(s) out of 518 units (allocation page 119296). 90% completed.

00:0002:00000:00001:2013/11/19 17:57:11.07 server  Processed 518 allocation unit(s) out of 518 units (allocation page 132352). 100% completed.

00:0002:00000:00001:2013/11/19 17:57:11.07 server  Tempdb 2 is added to the  list of local temporary databases

00:0002:00000:00001:2013/11/19 17:57:11.08 server  Timestamp for database 'tempdb' is (0x0000, 0x00001f37).

00:0002:00000:00001:2013/11/19 17:57:11.58 server  The transaction log in the database 'tempdb' will use I/O size of 16 Kb.

00:0002:00000:00001:2013/11/19 17:57:11.58 server  Database 'tempdb' is now online.

00:0002:00000:00001:2013/11/19 17:57:11.60 server  Recovering database 'sybsystemprocs'.

00:0002:00000:00001:2013/11/19 17:57:11.60 server  Started estimating recovery log boundaries for database 'sybsystemprocs'.

00:0002:00000:00001:2013/11/19 17:57:11.61 server  Database 'sybsystemprocs', checkpoint=(6863, 93), first=(6863, 93), last=(6863, 93).

00:0002:00000:00001:2013/11/19 17:57:11.61 server  Completed estimating recovery log boundaries for database 'sybsystemprocs'.

00:0002:00000:00001:2013/11/19 17:57:11.61 server  Started ANALYSIS pass for database 'sybsystemprocs'.

00:0002:00000:00001:2013/11/19 17:57:11.61 server  Completed ANALYSIS pass for database 'sybsystemprocs'.

00:0002:00000:00001:2013/11/19 17:57:11.61 server  Log contains all committed transactions until 2013/01/09 12:03:23.30 for database sybsystemprocs.

00:0002:00000:00001:2013/11/19 17:57:11.61 server  Started REDO pass for database 'sybsystemprocs'. The total number of log records to process is 1.

00:0002:00000:00001:2013/11/19 17:57:11.62 server  Completed REDO pass for database 'sybsystemprocs'.

00:0002:00000:00001:2013/11/19 17:57:11.95 server  Timestamp for database 'sybsystemprocs' is (0x0000, 0x001a76e1).

00:0002:00000:00001:2013/11/19 17:57:11.95 server  Recovery of database 'sybsystemprocs' will undo incomplete nested top actions.

00:0002:00000:00001:2013/11/19 17:57:11.96 server  Started recovery checkpoint for database 'sybsystemprocs'.

00:0002:00000:00001:2013/11/19 17:57:11.98 server  Completed recovery checkpoint for database 'sybsystemprocs'.

00:0002:00000:00001:2013/11/19 17:57:11.99 server  Started filling free space info for database 'sybsystemprocs'.

00:0002:00000:00001:2013/11/19 17:57:12.01 server  Completed filling free space info for database 'sybsystemprocs'.

00:0002:00000:00001:2013/11/19 17:57:12.02 server  Started cleaning up the default data cache for database 'sybsystemprocs'.

00:0002:00000:00001:2013/11/19 17:57:12.02 server  Completed cleaning up the default data cache for database 'sybsystemprocs'.

00:0002:00000:00001:2013/11/19 17:57:12.03 server  Checking external objects.

00:0002:00000:00001:2013/11/19 17:57:12.25 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 16 Kb.

00:0002:00000:00001:2013/11/19 17:57:12.26 server  Database 'sybsystemprocs' is now online.

00:0002:00000:00012:2013/11/19 17:57:12.27 kernel  network name vemeccdev, interface IPv4, address 192.168.10.18, type tcp, port 4901, filter NONE

00:0003:00000:00000:2013/11/19 17:57:12.28 kernel  Network and device connection limit is 65519.

00:0003:00000:00000:2013/11/19 17:57:12.28 kernel  Encryption provider initialization succeeded on engine 1.

00:0003:00000:00000:2013/11/19 17:57:12.28 kernel  Thread 3 (LWP 30212281) of Threadpool syb_default_pool online as engine 1

00:0005:00000:00000:2013/11/19 17:57:12.28 kernel  Network and device connection limit is 65519.

00:0005:00000:00000:2013/11/19 17:57:12.28 kernel  Encryption provider initialization succeeded on engine 3.

00:0005:00000:00000:2013/11/19 17:57:12.28 kernel  Thread 5 (LWP 57344095) of Threadpool syb_default_pool online as engine 3

00:0007:00000:00000:2013/11/19 17:57:12.28 kernel  Network and device connection limit is 65519.

00:0007:00000:00000:2013/11/19 17:57:12.28 kernel  Encryption provider initialization succeeded on engine 5.

00:0007:00000:00000:2013/11/19 17:57:12.28 kernel  Thread 7 (LWP 29229205) of Threadpool syb_default_pool online as engine 5

00:0009:00000:00000:2013/11/19 17:57:12.28 kernel  Network and device connection limit is 65519.

00:0009:00000:00000:2013/11/19 17:57:12.28 kernel  Encryption provider initialization succeeded on engine 7.

00:0009:00000:00000:2013/11/19 17:57:12.28 kernel  Thread 9 (LWP 47055039) of Threadpool syb_default_pool online as engine 7

00:0011:00000:00000:2013/11/19 17:57:12.28 kernel  Network and device connection limit is 65519.

00:0011:00000:00000:2013/11/19 17:57:12.28 kernel  Encryption provider initialization succeeded on engine 9.

00:0011:00000:00000:2013/11/19 17:57:12.28 kernel  Thread 11 (LWP 46923953) of Threadpool syb_default_pool online as engine 9

00:0013:00000:00000:2013/11/19 17:57:12.28 kernel  Network and device connection limit is 65519.

00:0013:00000:00000:2013/11/19 17:57:12.28 kernel  Encryption provider initialization succeeded on engine 11.

00:0013:00000:00000:2013/11/19 17:57:12.28 kernel  Thread 13 (LWP 47579311) of Threadpool syb_default_pool online as engine 11

00:0015:00000:00000:2013/11/19 17:57:12.28 kernel  Network and device connection limit is 65519.

00:0015:00000:00000:2013/11/19 17:57:12.28 kernel  Encryption provider initialization succeeded on engine 13.

00:0015:00000:00000:2013/11/19 17:57:12.28 kernel  Thread 15 (LWP 47710387) of Threadpool syb_default_pool online as engine 13

00:0017:00000:00000:2013/11/19 17:57:12.28 kernel  Network and device connection limit is 65519.

00:0017:00000:00000:2013/11/19 17:57:12.28 kernel  Encryption provider initialization succeeded on engine 15.

00:0017:00000:00000:2013/11/19 17:57:12.28 kernel  Thread 17 (LWP 47841463) of Threadpool syb_default_pool online as engine 15

00:0004:00000:00000:2013/11/19 17:57:12.28 kernel  Network and device connection limit is 65519.

00:0004:00000:00000:2013/11/19 17:57:12.28 kernel  Encryption provider initialization succeeded on engine 2.

00:0004:00000:00000:2013/11/19 17:57:12.28 kernel  Thread 4 (LWP 30146667) of Threadpool syb_default_pool online as engine 2

00:0006:00000:00000:2013/11/19 17:57:12.28 kernel  Network and device connection limit is 65519.

00:0006:00000:00000:2013/11/19 17:57:12.29 kernel  Encryption provider initialization succeeded on engine 4.

00:0006:00000:00000:2013/11/19 17:57:12.29 kernel  Thread 6 (LWP 19595417) of Threadpool syb_default_pool online as engine 4

00:0008:00000:00000:2013/11/19 17:57:12.29 kernel  Network and device connection limit is 65519.

00:0008:00000:00000:2013/11/19 17:57:12.29 kernel  Encryption provider initialization succeeded on engine 6.

00:0008:00000:00000:2013/11/19 17:57:12.29 kernel  Thread 8 (LWP 46858427) of Threadpool syb_default_pool online as engine 6

00:0010:00000:00000:2013/11/19 17:57:12.29 kernel  Network and device connection limit is 65519.

00:0010:00000:00000:2013/11/19 17:57:12.29 kernel  Encryption provider initialization succeeded on engine 8.

00:0010:00000:00000:2013/11/19 17:57:12.29 kernel  Thread 10 (LWP 46989503) of Threadpool syb_default_pool online as engine 8

00:0012:00000:00000:2013/11/19 17:57:12.29 kernel  Network and device connection limit is 65519.

00:0012:00000:00000:2013/11/19 17:57:12.29 kernel  Encryption provider initialization succeeded on engine 10.

00:0012:00000:00000:2013/11/19 17:57:12.29 kernel  Thread 12 (LWP 47513773) of Threadpool syb_default_pool online as engine 10

00:0014:00000:00000:2013/11/19 17:57:12.29 kernel  Network and device connection limit is 65519.

00:0014:00000:00000:2013/11/19 17:57:12.29 kernel  Encryption provider initialization succeeded on engine 12.

00:0014:00000:00000:2013/11/19 17:57:12.29 kernel  Thread 14 (LWP 47644849) of Threadpool syb_default_pool online as engine 12

00:0016:00000:00000:2013/11/19 17:57:12.29 kernel  Network and device connection limit is 65519.

00:0016:00000:00000:2013/11/19 17:57:12.29 kernel  Encryption provider initialization succeeded on engine 14.

00:0016:00000:00000:2013/11/19 17:57:12.29 kernel  Thread 16 (LWP 47775925) of Threadpool syb_default_pool online as engine 14

00:0002:00000:00001:2013/11/19 17:57:12.63 server  The wash size of the 16K buffer pool in cache default data cache has been changed from 10240 Kb to 6144 Kb due to a change in the size of the pool.

00:0002:00000:00001:2013/11/19 17:57:12.63 server  The wash size of the 16K buffer pool in cache default data cache has been changed from 10240 Kb to 6144 Kb due to a change in the size of the pool.

00:0002:00000:00001:2013/11/19 17:57:12.63 server  The wash size of the 16K buffer pool in cache default data cache has been changed from 10240 Kb to 6144 Kb due to a change in the size of the pool.

00:0002:00000:00001:2013/11/19 17:57:12.63 server  The wash size of the 16K buffer pool in cache default data cache has been changed from 10240 Kb to 6144 Kb due to a change in the size of the pool.

00:0002:00000:00001:2013/11/19 17:57:12.63 server  The wash size of the 16K buffer pool in cache default data cache has been changed from 10240 Kb to 6144 Kb due to a change in the size of the pool.

00:0002:00000:00001:2013/11/19 17:57:12.63 server  The wash size of the 16K buffer pool in cache default data cache has been changed from 10240 Kb to 6144 Kb due to a change in the size of the pool.

00:0002:00000:00001:2013/11/19 17:57:12.63 server  The wash size of the 16K buffer pool in cache default data cache has been changed from 10240 Kb to 6144 Kb due to a change in the size of the pool.

00:0002:00000:00001:2013/11/19 17:57:12.63 server  The wash size of the 16K buffer pool in cache default data cache has been changed from 10240 Kb to 6144 Kb due to a change in the size of the pool.

00:0002:00000:00001:2013/11/19 17:57:12.63 server  Recovery has tuned the size of '128K' pool in 'default data cache' to benefit recovery performance. The original configuration will be restored at the end of recovery.

00:0002:00000:00001:2013/11/19 17:57:12.63 server  Recovery has tuned the size of '16K' pool in 'default data cache' to benefit recovery performance. The original configuration will be restored at the end of recovery.

00:0002:00000:00001:2013/11/19 17:57:12.63 server  Recovery has tuned the '128K' pool in 'default data cache' by changing its 'local async prefetch limit' from 10 to 80. The original configuration will be restored at the end of recovery.

00:0002:00000:00001:2013/11/19 17:57:12.63 server  Recovery has tuned the '16K' pool in 'default data cache' by changing its 'local async prefetch limit' from 10 to 80. The original configuration will be restored at the end of recovery.

00:0002:00000:00014:2013/11/19 17:57:12.67 server  Recovering database 'VED'.

00:0002:00000:00014:2013/11/19 17:57:12.67 server  Started estimating recovery log boundaries for database 'VED'.

00:0002:00000:00014:2013/11/19 17:57:12.67 server  Database 'VED', checkpoint=(8392762, 68), first=(8392762, 68), last=(8392762, 68).

00:0002:00000:00014:2013/11/19 17:57:12.67 server  Completed estimating recovery log boundaries for database 'VED'.

00:0002:00000:00014:2013/11/19 17:57:12.67 server  Started ANALYSIS pass for database 'VED'.

00:0002:00000:00014:2013/11/19 17:57:12.67 server  Completed ANALYSIS pass for database 'VED'.

00:0002:00000:00014:2013/11/19 17:57:12.67 server  Log contains all committed transactions until 2013/11/19 17:56:17.47 for database VED.

00:0002:00000:00014:2013/11/19 17:57:12.67 server  Started REDO pass for database 'VED'. The total number of log records to process is 1.

00:0002:00000:00014:2013/11/19 17:57:12.67 server  Completed REDO pass for database 'VED'.

00:0002:00000:00014:2013/11/19 17:57:12.67 server  Timestamp for database 'VED' is (0x0000, 0x4542b4b1).

00:0002:00000:00014:2013/11/19 17:57:12.67 server  Recovery of database 'VED' will undo incomplete nested top actions.

00:0002:00000:00014:2013/11/19 17:57:12.68 server  Started recovery checkpoint for database 'VED'.

00:0002:00000:00014:2013/11/19 17:57:12.68 server  Completed recovery checkpoint for database 'VED'.

00:0002:00000:00014:2013/11/19 17:57:12.68 server  Started filling free space info for database 'VED'.

00:0002:00000:00014:2013/11/19 17:57:12.68 server  Completed filling free space info for database 'VED'.

00:0002:00000:00014:2013/11/19 17:57:12.69 server  Started cleaning up the default data cache for database 'VED'.

00:0002:00000:00014:2013/11/19 17:57:13.14 server  Completed cleaning up the default data cache for database 'VED'.

00:0002:00000:00014:2013/11/19 17:57:13.14 server  Checking external objects.

00:0002:00000:00015:2013/11/19 17:57:13.57 server  Recovering database 'saptools'.

00:0002:00000:00015:2013/11/19 17:57:13.57 server  Started estimating recovery log boundaries for database 'saptools'.

00:0002:00000:00015:2013/11/19 17:57:13.58 server  Database 'saptools', checkpoint=(138287, 100), first=(138287, 100), last=(138287, 100).

00:0002:00000:00015:2013/11/19 17:57:13.58 server  Completed estimating recovery log boundaries for database 'saptools'.

00:0002:00000:00015:2013/11/19 17:57:13.58 server  Started ANALYSIS pass for database 'saptools'.

00:0002:00000:00015:2013/11/19 17:57:13.58 server  Completed ANALYSIS pass for database 'saptools'.

00:0002:00000:00015:2013/11/19 17:57:13.58 server  Log contains all committed transactions until 2013/11/19 17:56:17.47 for database saptools.

00:0002:00000:00015:2013/11/19 17:57:13.58 server  Started REDO pass for database 'saptools'. The total number of log records to process is 1.

00:0002:00000:00015:2013/11/19 17:57:13.58 server  Completed REDO pass for database 'saptools'.

00:0002:00000:00015:2013/11/19 17:57:13.58 server  Timestamp for database 'saptools' is (0x0000, 0x2c45a832).

00:0002:00000:00015:2013/11/19 17:57:13.58 server  Recovery of database 'saptools' will undo incomplete nested top actions.

00:0002:00000:00015:2013/11/19 17:57:13.58 server  Started recovery checkpoint for database 'saptools'.

00:0002:00000:00015:2013/11/19 17:57:13.58 server  Completed recovery checkpoint for database 'saptools'.

00:0002:00000:00015:2013/11/19 17:57:13.59 server  Started filling free space info for database 'saptools'.

00:0003:00000:00015:2013/11/19 17:57:13.94 server  Completed filling free space info for database 'saptools'.

00:0003:00000:00015:2013/11/19 17:57:13.95 server  Started cleaning up the default data cache for database 'saptools'.

00:0003:00000:00014:2013/11/19 17:57:13.95 server  The transaction log in the database 'VED' will use I/O size of 16 Kb.

00:0003:00000:00014:2013/11/19 17:57:13.96 server  Database 'VED' is now online.

00:0003:00000:00014:2013/11/19 17:57:14.03 server  Recovering database 'sybmgmtdb'.

00:0003:00000:00014:2013/11/19 17:57:14.04 server  Started estimating recovery log boundaries for database 'sybmgmtdb'.

00:0003:00000:00014:2013/11/19 17:57:14.06 server  Database 'sybmgmtdb', checkpoint=(4528, 59), first=(4528, 59), last=(4528, 59).

00:0003:00000:00014:2013/11/19 17:57:14.06 server  Completed estimating recovery log boundaries for database 'sybmgmtdb'.

00:0003:00000:00014:2013/11/19 17:57:14.06 server  Started ANALYSIS pass for database 'sybmgmtdb'.

00:0003:00000:00014:2013/11/19 17:57:14.06 server  Completed ANALYSIS pass for database 'sybmgmtdb'.

00:0003:00000:00014:2013/11/19 17:57:14.06 server  Log contains all committed transactions until 2013/11/19 17:56:17.47 for database sybmgmtdb.

00:0003:00000:00014:2013/11/19 17:57:14.06 server  Started REDO pass for database 'sybmgmtdb'. The total number of log records to process is 1.

00:0003:00000:00014:2013/11/19 17:57:14.06 server  Completed REDO pass for database 'sybmgmtdb'.

00:0003:00000:00014:2013/11/19 17:57:14.23 server  Timestamp for database 'sybmgmtdb' is (0x0000, 0x00e6bc79).

00:0003:00000:00014:2013/11/19 17:57:14.23 server  Recovery of database 'sybmgmtdb' will undo incomplete nested top actions.

00:0003:00000:00014:2013/11/19 17:57:14.24 server  Started recovery checkpoint for database 'sybmgmtdb'.

00:0003:00000:00015:2013/11/19 17:57:14.72 server  Completed cleaning up the default data cache for database 'saptools'.

00:0003:00000:00014:2013/11/19 17:57:14.74 server  Completed recovery checkpoint for database 'sybmgmtdb'.

00:0003:00000:00015:2013/11/19 17:57:14.74 server  Checking external objects.

00:0003:00000:00014:2013/11/19 17:57:14.74 server  Started filling free space info for database 'sybmgmtdb'.

00:0003:00000:00014:2013/11/19 17:57:14.74 server  Completed filling free space info for database 'sybmgmtdb'.

00:0003:00000:00014:2013/11/19 17:57:14.74 server  Started cleaning up the default data cache for database 'sybmgmtdb'.

00:0017:00000:00014:2013/11/19 17:57:15.44 server  Completed cleaning up the default data cache for database 'sybmgmtdb'.

00:0017:00000:00014:2013/11/19 17:57:15.44 server  Checking external objects.

00:0017:00000:00015:2013/11/19 17:57:15.45 server  The transaction log in the database 'saptools' will use I/O size of 16 Kb.

00:0017:00000:00015:2013/11/19 17:57:15.45 server  Database 'saptools' is now online.

00:0002:00000:00001:2013/11/19 17:57:15.55 server  The optimal number of recovery processes is 3.

00:0013:00000:00014:2013/11/19 17:57:16.03 server  The transaction log in the database 'sybmgmtdb' will use I/O size of 16 Kb.

00:0013:00000:00014:2013/11/19 17:57:16.03 server  Database 'sybmgmtdb' is now online.

00:0002:00000:00001:2013/11/19 17:57:16.03 server  Recovery has restored the value of 'local async prefetch limit' for '128K' pool in 'default data cache' from '80' to 'DEFAULT'.

00:0002:00000:00001:2013/11/19 17:57:16.03 server  Recovery has restored the value of 'local async prefetch limit' for '16K' pool in 'default data cache' from '80' to 'DEFAULT'.

00:0002:00000:00001:2013/11/19 17:57:16.04 server  Recovery has restored the original size for '128K' pool and '16K' pool in 'default data cache'.

00:0002:00000:00001:2013/11/19 17:57:16.05 server  Recovery complete.

00:0002:00000:00001:2013/11/19 17:57:16.05 server  ASE's default unicode sort order is 'binary'.

00:0002:00000:00001:2013/11/19 17:57:16.05 server  ASE's default sort order is:

00:0002:00000:00001:2013/11/19 17:57:16.05 server      'binary' (ID = 25)

00:0002:00000:00001:2013/11/19 17:57:16.05 server  on top of default character set:

00:0002:00000:00001:2013/11/19 17:57:16.05 server      'utf8' (ID = 190).

00:0002:00000:00001:2013/11/19 17:57:16.05 server  Master device size: 400 megabytes, or 204800 virtual pages. (A virtual page is 2048 bytes.)

00:0013:00000:00017:2013/11/19 17:57:16.07 kernel  Initializing Job Scheduler Task

00:0013:00000:00017:2013/11/19 17:57:16.26 kernel  Installed Job Scheduler sequencer code version 0.29 - 29 tokens

00:0011:00000:00017:2013/11/19 17:57:17.92 kernel  Job Scheduler Task state set to running, startcount 1.

00:0011:00000:00017:2013/11/19 17:57:18.85 kernel  Job Scheduler Task connected with Agent on port 4903

00:0002:00000:00001:2013/11/19 17:57:18.85 kernel  Warning: Cannot set console to nonblocking mode, switching to blocking mode.

00:0002:00000:00001:2013/11/19 17:57:19.33 kernel  Console logging is disabled. This is controlled via the 'enable console logging' configuration parameter.

00:0007:00000:00216:2013/11/20 00:02:49.92 server  Error: 1105, Severity: 17, State: 2

00:0007:00000:00216:2013/11/20 00:02:49.92 server  Can't allocate space for object 'DBH_SNAP_TABLES' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

00:0017:00000:00228:2013/11/20 12:00:36.80 server  Error: 1105, Severity: 17, State: 2

00:0017:00000:00228:2013/11/20 12:00:36.80 server  Can't allocate space for object 'DBH_SNAP_TABLES' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

00:0017:00000:00011:2013/11/20 17:58:14.03 kernel  Begin processing to generate RSA keypair.

00:0017:00000:00011:2013/11/20 17:58:14.07 kernel  Completed processing to generate RSA keypair.

00:0017:00000:00011:2013/11/20 17:58:14.07 kernel  Begin processing to generate RSA keypair.

00:0017:00000:00011:2013/11/20 17:58:14.14 kernel  Completed processing to generate RSA keypair.

00:0012:00000:00226:2013/11/21 00:00:04.76 server  Error: 1105, Severity: 17, State: 2

00:0012:00000:00226:2013/11/21 00:00:04.76 server  Can't allocate space for object 'DBH_SNAP_TABLES' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

00:0002:00000:00053:2013/11/21 12:00:04.36 server  Error: 1105, Severity: 17, State: 2

00:0002:00000:00053:2013/11/21 12:00:04.36 server  Can't allocate space for object 'DBH_SNAP_TABLES' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

00:0017:00000:00008:2013/11/21 14:13:13.07 server  WARNING: The transaction log for database 'saptools' (dbid 5) can no longer be dumped due to user '' (suid 0) executing DUMP TRAN WITH TRUNCATE_ONLY.

00:0017:00000:00011:2013/11/21 17:59:58.67 kernel  Begin processing to generate RSA keypair.

00:0017:00000:00011:2013/11/21 17:59:58.69 kernel  Completed processing to generate RSA keypair.

00:0017:00000:00011:2013/11/21 17:59:58.69 kernel  Begin processing to generate RSA keypair.

00:0017:00000:00011:2013/11/21 17:59:58.71 kernel  Completed processing to generate RSA keypair.

00:0006:00000:00085:2013/11/22 00:01:07.14 server  Error: 1105, Severity: 17, State: 2

00:0006:00000:00085:2013/11/22 00:01:07.14 server  Can't allocate space for object 'DBH_SNAP_TABLES' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

00:0004:00000:00221:2013/11/22 12:00:03.43 server  Error: 1105, Severity: 17, State: 2

00:0004:00000:00221:2013/11/22 12:00:03.43 server  Can't allocate space for object 'DBH_SNAP_TABLES' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

00:0017:00000:00011:2013/11/22 18:01:21.35 kernel  Begin processing to generate RSA keypair.

00:0017:00000:00011:2013/11/22 18:01:21.42 kernel  Completed processing to generate RSA keypair.

00:0017:00000:00011:2013/11/22 18:01:21.42 kernel  Begin processing to generate RSA keypair.

00:0017:00000:00011:2013/11/22 18:01:21.47 kernel  Completed processing to generate RSA keypair.

00:0017:00000:00257:2013/11/23 00:00:55.80 server  Error: 1105, Severity: 17, State: 2

00:0017:00000:00257:2013/11/23 00:00:55.80 server  Can't allocate space for object 'DBH_SNAP_TABLES' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

00:0007:00000:00008:2013/11/23 10:59:13.12 server  WARNING: The transaction log for database 'saptools' (dbid 5) can no longer be dumped due to user '' (suid 0) executing DUMP TRAN WITH TRUNCATE_ONLY.

00:0006:00000:00199:2013/11/23 12:00:02.73 server  Error: 1105, Severity: 17, State: 2

00:0006:00000:00199:2013/11/23 12:00:02.73 server  Can't allocate space for object 'DBH_SNAP_TABLES' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

00:0022:00000:00000:2013/11/23 17:20:22.99 kernel  WriteFile error: status 32 vsn 116

00:0006:00000:00226:2013/11/23 17:20:22.99 server  Shutdown started by user 'sapsa'. SQL text: shutdown with wait = '00:02:00'

00:0010:00000:00017:2013/11/23 17:20:23.29 kernel  Job Scheduler Agent has shutdown.

00:0010:00000:00017:2013/11/23 17:20:23.43 kernel  Job Scheduler Task state set to stop

00:0007:00000:00226:2013/11/23 17:20:23.83 server  ASE shutdown by request.

00:0007:00000:00226:2013/11/23 17:20:23.83 kernel  ueshutdown: exiting

00:0000:00000:00000:2013/11/23 17:20:23.83 kernel  Main thread performing final shutdown.

00:0000:00000:00000:2013/11/23 17:20:23.89 kernel  Blocking call queue shutdown.

00:0000:00000:00000:2013/11/23 17:20:23.99 kernel  SySAM: Checked in license for 8 ASE_ASM (2013.1231/permanent/0AA8 42CE 5872 3BD7).

00:0000:00000:00000:2013/11/23 17:20:23.99 kernel  SySAM: Checked in license for 8 ASE_CORE (2013.1231/permanent/0AA8 42CE 5872 3BD7).

00:0000:00000:00000:2013/11/23 17:20:23.99 kernel  SySAM: Checked in license for 8 ASE_PARTITIONS (2013.1231/permanent/0AA8 42CE 5872 3BD7).

00:0000:00000:00000:2013/11/23 17:20:23.99 kernel  SySAM: Checked in license for 8 ASE_COMPRESSION (2013.1231/permanent/0AA8 42CE 5872 3BD7).

Show replies
Show replies
kimon_moschandreou
Contributor
‎01-03-2014 10:59 AM
0 Kudos

Hi again,

You need to add some space, I am afraid I cannot guide you through dbacockpit, but I may send you some SQL commands. Please send me the

sp_helpdb saptools

in order to send you the commands that resize a device and add some space to the database

Best regards,

Kimon

kimon_moschandreou
Contributor
‎01-03-2014 11:09 AM
0 Kudos

Hi,

Now I see the whole log, I cannot suggest a specific size the following will add 5GB

disk resize name='datasaptools_1',size='5120M'

go

alter database saptools on datasaptools_1='5120M'

go

Also have a look at this in order to have databases expand automatically

SyBooks Online

Regards,

Kimon

Former Member
‎01-03-2014 8:44 AM
0 Kudos

Hi all,

      thanks for the reply.

      now i am able to login.

      when i try to retart only the saptools database. it says recovery failed

      it is marked suspect.

     i am unable to restore with the old saptools database backup.

     so i have two options.

  

      1. one is to reset the status of the database with "sp_resetstatus". which turns of the

          suspect status. leaving all the other database option intact.

      2 . drop the database and restore the old database.

  ** but i am not 100% sure about the sp_resetstatus. how the system would respond.

need your valuable suggestions

thanks 

Show replies
Show replies
kimon_moschandreou
Contributor
‎01-03-2014 9:08 AM
0 Kudos

Hi,

Run

select @@errorlog

and post the file to see what is happening

Regards,

Kimon

Former Member
‎12-27-2013 1:46 PM
0 Kudos

Hi,

       thanks for the response,

      I cant even login to isql, at login in command pormpt  it says " Database saptools is already           

      shutdown msg 4001, level 11, state 2."

      so i cant check sp_helpdb,

     is there any other way

thanks and regards

thomus

Show replies
Show replies
Former Member
‎01-03-2014 4:02 AM
0 Kudos

Hi thomus,

in general, Error 4001 is raised when Adaptive Server is unable to open the users

default database at login.

I think saptools database transaction log is full so it maybe suspened now.

so follow me as below.

1. unlock sa login with sapsso

    #isql -Usapsso -Pmasterpass -SSID

    1> sp_locklogin 'unlock',sa

    2> go

2. dump tran saptools DB with sa

    #isql -Usa -Pmasterpass -SSID

    1> dump tran saptools with truncate_only

    2> go

3. try login again with sapsa

    #isql -Usapsa -Pmasterpass -SSID

Regards,

sang-wook.

Former Member
‎12-18-2013 5:35 AM
0 Kudos

Hi,

    after i restart the sybase database and sap system, in dbacockpit it says

    "sybase ase error sql 4001 cannot open default database saptools"

     in the SID.log also it says the same thing.

     as i had performed the "prune data", is it required to again archive log.

need some input on this.

thanks

Show replies
Show replies
Former Member
‎12-24-2013 10:16 AM
0 Kudos

Hi,

Request you to please check the space availability in your saptools database. You can use the sp_helpdb procedure to check this.

Thanks

Surajit

kimon_moschandreou
Contributor
‎01-03-2014 8:22 AM
0 Kudos

Hello,

I think you need to find the error log of ASE server (probably in $SYBASe/ASE-15_0/install as Bret suggested) or login using another login if possible (a login with sa_role)

Regards,

Kimon

kimon_moschandreou
Contributor
‎12-03-2013 3:06 PM
0 Kudos

Hello,

the saptools database is not online, the ASE error log is required to see what happened. Maybe if you run

online database saptools

will also tell you what is the problem

Best regards,

Kimon

Show replies
Show replies
Former Member
‎12-06-2013 6:59 AM
0 Kudos

Hi

thanks for the response

       but i want to know sybase error log file location path.

    

       we are on AIX operating system.

thanks

former_member188958
Active Contributor
‎12-06-2013 4:24 PM
0 Kudos

The typical location of the ASE errorlog is in the directory

$SYBASE/ASE-15*/install

with the file typically having the name of the server ($DSQUERY)  appended with ".log"

Former Member
‎12-08-2013 2:15 AM
0 Kudos

Adding inline with above, you can also archive the errorlog using sp_errorlog system procedure. It does not require any down time. Also if you can put errorlog as per your requirement.

If you need any more info, please let us know. Thanks,

Ask a Question