docker - SAP Adaptive Server Enterprise 컨테이너 실행
SAP ASE 제품도 현재 공식 이미지는 제공되지 않습니다. 그래서 다음의 이미지를 사용해 볼 텐데,
nguoianphu/docker-sybase
; https://hub.docker.com/r/nguoianphu/docker-sybase
docker pull nguoianphu/docker-sybase
docker run --name ase16 -p 5000:5000 -p 5001:5001 nguoianphu/docker-sybase
docker run --name ase16 --restart=always -d -p 5000:5000 -p 5001:5001 nguoianphu/docker-sybase
다음의 계정과 서버 인스턴스로 미리 설정되어 있습니다.
USER: sa
PASSWORD: myPassword
Server: MYSYBASE
그런데... 아쉽게도 공식적인 GUI 클라이언트가 없습니다. (혹시 쓸만한 GUI 도구를 아시는 분은 덧글 부탁드립니다. ^^)
Where is PC Client for ASE?
; https://archive.sap.com/documents/docs/DOC-56188
Starting with SAP ASE 16.0 there is NO longer a PC -Client for Windows.
Instead you will get the SDK (Software Devlopers Kit) for SAP ASE and then pick the Windows platform.
대신 해당 컨테이너에 포함된 isql 명령행 인터페이스를 실행해 볼 수 있는데, 편의성을 위해 "/opt/sybase/SYBASE.sh" 파일에 대해 source 명령어를 실행 후 구동할 수 있습니다.
c:\temp> docker exec -it ase16 /bin/bash
[root@68e80d681ccd bin]# source /opt/sybase/SYBASE.sh
[root@68e80d681ccd /]# find / -name isql
/opt/sybase/OCS-16_0/bin/isql
[root@68e80d681ccd /]# isql -U sa -P myPassword -S MYSYBASE
1> select @@version
2> go
---------------------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/16.0 SP02 PL02/EBF 25320 SMP/P/x86_64/Enterprise Linux/ase160sp02plx/2492/64-bit/FBO/Sat Nov 21 04:05:39 2015
(1 row affected)
또는 원격에서 접속하는 경우라면 "-S" 옵션에 IP와 포트를 함께 지정하면 됩니다.
c:\SAP\OCS-16_0\bin> isql -U sa -P myPassword -S 192.168.100.50:5000
1>
마지막으로 데이터베이스 유지를 위한 볼륨은 /opt/sybase/data로 연결하면 되고.
c:\temp> docker run --name ase16 -v ase16:/opt/sybase/data -p 5000:5000 -p 5001:5001 nguoianphu/docker-sybase
isql 내에서의 명령은 다음의 문서를 참조하면 됩니다.
SAP Adaptive Server Enterprise 16.0 > Reference Manual: Commands 16.0
; http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc36272.1600/doc/html/san1393050880067.html
SYBASE 기본 사용법(시작/종료, Login/Logout, DB생성/삭제/변경, Device등록/삭제,
; http://pchero21.com/?p=990
아래는 기본적인 동작 몇 가지를 수행한 것입니다.
1> sp_helpdb
2> go
name db_size owner dbid created durability lobcomplvl inrowlen status
-------------- ------------- ----- ----- ------------ ----------- ---------- -------- -----------
master 300.0 MB sa 1 Nov 17, 2016 full 0 NULL mixed log and data
model 24.0 MB sa 3 Nov 17, 2016 full 0 NULL mixed log and data
sybpcidb 384.0 MB sa 31515 Nov 17, 2016 full 0 NULL select into/bulkcopy/pllsort, mixed log and data
sybsystemdb 48.0 MB sa 31513 Nov 17, 2016 full 0 NULL mixed log and data
sybsystemprocs 184.0 MB sa 31514 Nov 17, 2016 full 0 NULL trunc log on chkpt, mixed log and data
tempdb 348.0 MB sa 2 Mar 15, 2020 no_recovery 0 NULL select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data, allow wide dol rows
(1 row affected)
(return status = 0)
1> select db_name()
2> go
------------------------------
master
(1 row affected)
1> disk init name="testdb_dev", physname="/opt/sybase/data/testdb.dat", size="60M"
2> go
1> create database testdb on testdb_dev
2> go
CREATE DATABASE: allocating 1536 logical pages (24.0 megabytes) on disk
'testdb_dev' (1536 logical pages requested).
Database 'testdb' is now online.
1> use testdb
2> go
1> select db_name()
2> go
------------------------------
testdb
(1 row affected)
1> create table foo (a int, b int default @@spid)
2> go
1> create table testtable (PersonID int not null unique, FirstName varchar (50), LastName varchar (50), Address varchar (150), City varchar (50))
2> go
이런 식으로 데이터베이스와 테이블을 구성했으면 ADO.NET을 이용해 개발을 진행하면 됩니다. ^^
닷넷에서 SAP Adaptive Server Enterprise 데이터베이스 사용
; https://www.sysnet.pe.kr/2/0/10884
참고로, 다음은 정상적으로 실행된 경우 출력되는 로그입니다.
C:\temp> docker run --name ase16 -p 5000:5000 -p 5001:5001 nguoianphu/docker-sybase
00:0000:00000:00000:2020/03/15 07:55:30.25 kernel SySAM: Using licenses from: /opt/sybase/SYSAM-2_0/licenses/SYBASE_ASE_DE.lic:/opt/sybase/SYSAM-2_0/licenses/SYBASE_ASE_XE.lic
00:0000:00000:00000:2020/03/15 07:55:30.38 kernel SySAM: Checked out license for 1 ASE_CORE (2018.1231/permanent/0534 6FD0 8CE5 427C).
00:0000:00000:00000:2020/03/15 07:55:30.38 kernel This product is licensed to: ASE Developer Edition - For Development and Test use only
00:0000:00000:00000:2020/03/15 07:55:30.38 kernel Checked out license ASE_CORE
00:0000:00000:00000:2020/03/15 07:55:30.38 kernel Adaptive Server Enterprise (Developer Edition)
00:0000:00000:00000:2020/03/15 07:55:30.49 kernel Using config area from primary master device.
00:0000:00000:00000:2020/03/15 07:55:30.66 kernel Could not allocate memory using Huge Pages. Allocated using regular pages. For better performance, reboot the server after configuring enough Huge Pages.
00:0000:00000:00000:2020/03/15 07:55:30.66 kernel Internal run-time model set for Linux - Native
00:0000:00000:00000:2020/03/15 07:55:30.66 kernel Adaptive Server is using the threaded kernel mode.
00:0000:00000:00000:2020/03/15 07:55:30.66 kernel Using 40000 file descriptors.
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel Adaptive Server Enterprise/16.0 SP02 PL02/EBF 25320 SMP/P/x86_64/Enterprise Linux/ase160sp02plx/2492/64-bit/FBO/Sat Nov 21 04:05:39 2015
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel Confidential property of SAP AG or an SAP affiliate company.
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel Copyright 2015
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel SAP AG or an SAP affiliate company. All rights reserved.
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel Unpublished rights reserved under U.S. copyright laws.
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel This software contains confidential and trade secret information of SAP AG or
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel an SAP affiliate company. Use, duplication or disclosure of the software and
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel documentation by the U.S. Government is subject to restrictions set forth
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel in a license agreement between the Government and SAP AG or an SAP affiliate
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel company, or other written agreement specifying the Government's rights to
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel use the software and any applicable FAR provisions, for example, FAR 52.227-19.
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel SAP AG or an SAP affiliate company
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel Using /opt/sybase as the 'SYBASE' environment variable, found during startup.
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel Using OCS-16_0 as the 'SYBASE_OCS' environment variable, found during startup.
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel Using ASE-16_0 as the 'SYBASE_ASE' environment variable, found during startup.
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel ASE booted on host '558155c16004' running Linux release 4.19.76-linuxkit version #1 SMP Thu Oct 17 19:31:58 UTC 2019.
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel Using '/opt/sybase/ASE-16_0/MYSYBASE.cfg' for configuration information.
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel Logging ASE messages in file '/opt/sybase/ASE-16_0/install/MYSYBASE.log'.
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel Disk Controller Manager is online.
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel Network Controller Manager is online.
00:0000:00000:00000:2020/03/15 07:55:30.68 kernel Ct-Lib Controller Manager is online.
00:0000:00000:00000:2020/03/15 07:55:30.69 kernel Platform TCP network support seems IPv6-aware, IPv4/IPv6 are both enabled.
00:0000:00000:00000:2020/03/15 07:55:30.69 kernel ASE booted with TCP_NODELAY enabled.
00:0000:00000:00000:2020/03/15 07:55:30.71 kernel ASE - Dynamic Pluggable Component Interface is enabled
00:0000:00000:00000:2020/03/15 07:55:30.71 kernel PCI(M0): PCI Memory not available, initializing now....
00:0000:00000:00000:2020/03/15 07:55:30.71 kernel PCI(M0): 64.0 Mb. allocated for the PCI Memory pool ....
00:0000:00000:00000:2020/03/15 07:55:30.71 kernel ASE_PCI: 4 slot(s) available
00:0000:00000:00000:2020/03/15 07:55:30.71 kernel PCI(M0): PCI Bridge initializing the PLB for 4 slots
00:0000:00000:00000:2020/03/15 07:55:30.71 kernel PCI(M0): PCI Bridge escapes large memory allocation requests to the run-time
00:0000:00000:00000:2020/03/15 07:55:30.71 kernel PCI(M1): Slot 1 has been bound to engine 0
00:0000:00000:00000:2020/03/15 07:55:30.71 kernel PCI(M1): Slot 2 has been bound to engine 0
00:0000:00000:00000:2020/03/15 07:55:30.71 kernel PCI(M1): PCI Bridge Slot# 1, Module "JVM Adaptor", Vendor "Sybase an SAP Company", Logical name "PCA/JVM"
00:0000:00000:00000:2020/03/15 07:55:30.71 kernel PCI(M1): PCI Bridge Slot# 2, Module "ODBC Adaptor", Vendor "Sybase an SAP Company", Logical name "PCA/ODBC"
00:0000:00000:00000:2020/03/15 07:55:30.71 kernel Network and device connection limit is 39985.
00:0000:00000:00000:2020/03/15 07:55:30.73 kernel Adaptive Server is running as process id 7.
00:0000:00000:00000:2020/03/15 07:55:30.90 server Number of blocks left for proc headers: 13976.
00:0000:00000:00000:2020/03/15 07:55:30.91 server Proc header memory allocated 6950 pages for each per engine cache.
00:0000:00000:00000:2020/03/15 07:55:30.94 kernel Create Thread Pool 2, "syb_system_pool", type="Run To Completion", with 1 threads
00:0000:00000:00000:2020/03/15 07:55:30.95 kernel Warning: Operating System stack size is greater than 2MB. If it is too large, ASE may run out of memory during thread creation. You can reconfigure it using 'limit' (csh) or 'ulimit' (bash)
00:0000:00000:00000:2020/03/15 07:55:30.95 kernel Create Thread Pool 1, "syb_default_pool", type="Engine (Multiplexed)", with 1 threads
00:0000:00000:00000:2020/03/15 07:55:30.95 kernel Aggressive task stealing enabled
00:0000:00000:00000:2020/03/15 07:55:30.95 kernel Create Thread Pool 3, "syb_blocking_pool", type="Run To Completion", with 4 threads
00:0007:00000:00000:2020/03/15 07:55:31.08 kernel I/O controller 2 (NetController) is running as task 786438 on thread 7 (LWP 20).
00:0000:00000:00000:2020/03/15 07:55:31.08 kernel Enabling Linux Native Kernel asynchronous disk I/O strategy.
00:0008:00000:00000:2020/03/15 07:55:31.08 kernel I/O controller 3 (DiskController) is running as task 917511 on thread 8 (LWP 21).
00:0000:00000:00000:2020/03/15 07:55:31.08 kernel Initializing virtual device 0, '/opt/sybase/data/master.dat' with dsync 'off'.
00:0000:00000:00000:2020/03/15 07:55:31.08 kernel Virtual device 0 started using asynchronous (with DIRECTIO) i/o.
00:0000:00000:00000:2020/03/15 07:55:31.08 server Loaded default Unilib conversion handle.
00:0000:00000:00000:2020/03/15 07:55:31.08 kernel Worker Thread Manager is not enabled for use in ASE.
00:0000:00000:00000:2020/03/15 07:55:31.08 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:2020/03/15 07:55:31.15 kernel libsybibmmq - Sybase IBM MQ interface/16.0 SP02 PL02/EBF 25320 SMP/P/x86_64/Enterprise Linux/ase160sp02plx/2492/64-bit/OPT/Sat Nov 21 02:29:37 2015
00:0000:00000:00000:2020/03/15 07:55:31.20 kernel Loaded encryption provider CSI-2.9M18-linuxamd64-2015/07/13 21:00:24 PDT-sybcsi_openssl-OpenSSL 1.0.1p-fips 9 Jul 2015.
00:0000:00000:00000:2020/03/15 07:55:31.20 kernel Begin processing to generate RSA keypair.
00:0000:00000:00000:2020/03/15 07:55:31.23 kernel Completed processing to generate RSA keypair.
00:0000:00000:00000:2020/03/15 07:55:31.23 kernel Begin processing to generate RSA keypair.
00:0000:00000:00000:2020/03/15 07:55:31.28 kernel Completed processing to generate RSA keypair.
00:0002:00000:00000:2020/03/15 07:55:31.32 kernel ASE - Dynamic Pluggable Component Interface is enabled
00:0002:00000:00000:2020/03/15 07:55:31.32 kernel Thread 2 (LWP 10) of Threadpool syb_default_pool online as engine 0
00:0002:00000:00000:2020/03/15 07:55:31.32 kernel bucket manager consolidator online
00:0002:00000:00000:2020/03/15 07:55:31.54 server No active traceflags
00:0002:00000:00002:2020/03/15 07:55:31.55 kernel libomni1 - Component Integration Services: using 'SAP Client-Library/16.0 SP02 PL02/P-EBF25246/DRV.16.0.02.02/Linux x86_64/Linux 2.6.18-128.el5 x86_64 Native Threads/BUILD1600-010/64bit/OPT/Mon Sep 28 05:52:23 2015'
00:0002:00000:00002:2020/03/15 07:55:31.56 server Size of the 16K memory pool for each cachelet (default data cache, total cachelets:1 ): 8192 Kb
00:0002:00000:00002:2020/03/15 07:55:31.56 server Opening Master Database ...
00:0002:00000:00002:2020/03/15 07:55:31.78 server Loading ASE's default sort order and character set
00:0002:00000:00002:2020/03/15 07:55:31.85 server Recovering database 'master'.
00:0002:00000:00002:2020/03/15 07:55:31.89 server Started estimating recovery log boundaries for database 'master'.
00:0002:00000:00002:2020/03/15 07:55:31.92 server Database 'master', checkpoint=(2118, 20), first=(2118, 20), last=(2118, 43).
00:0002:00000:00002:2020/03/15 07:55:31.92 server Completed estimating recovery log boundaries for database 'master'.
00:0002:00000:00002:2020/03/15 07:55:31.92 server Started ANALYSIS pass for database 'master'.
00:0002:00000:00002:2020/03/15 07:55:31.94 server Completed ANALYSIS pass for database 'master'.
00:0002:00000:00002:2020/03/15 07:55:31.94 server Log contains all committed transactions until 2016/11/17 09:57:36.12 for database master.
00:0002:00000:00002:2020/03/15 07:55:31.94 server Started REDO pass for database 'master'. The total number of log records to process is 24.
00:0002:00000:00002:2020/03/15 07:55:31.98 server Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:0002:00000:00002:2020/03/15 07:55:31.98 server Completed REDO pass for database 'master'.
00:0002:00000:00002:2020/03/15 07:55:32.38 server Timestamp for database 'master' is (0x0000, 0x00011fef).
00:0002:00000:00002:2020/03/15 07:55:32.38 server Recovery of database 'master' will undo incomplete nested top actions.
00:0002:00000:00002:2020/03/15 07:55:32.39 server Started recovery checkpoint for database 'master'.
00:0002:00000:00002:2020/03/15 07:55:32.53 server Completed recovery checkpoint for database 'master'.
00:0002:00000:00002:2020/03/15 07:55:32.60 server Started filling free space info for database 'master'.
00:0002:00000:00002:2020/03/15 07:55:32.62 server Completed filling free space info for database 'master'.
00:0002:00000:00002:2020/03/15 07:55:32.65 server Started cleaning up the default data cache for database 'master'.
00:0002:00000:00002:2020/03/15 07:55:32.65 server Completed cleaning up the default data cache for database 'master'.
00:0002:00000:00002:2020/03/15 07:55:32.76 server Database 'master' is now online.
00:0002:00000:00002:2020/03/15 07:55:32.76 server The transaction log in the database 'master' will use I/O size of 16 Kb.
00:0002:00000:00002:2020/03/15 07:55:32.99 server server name is 'MYSYBASE'
00:0002:00000:00002:2020/03/15 07:55:33.20 server Activating disk 'sysprocsdev' of size 188416 KB.
00:0002:00000:00002:2020/03/15 07:55:34.55 kernel Initializing virtual device 1, '/opt/sybase/data/sysprocs.dat' with dsync 'off'.
00:0002:00000:00002:2020/03/15 07:55:34.55 kernel Virtual device 1 started using asynchronous (with DIRECTIO) i/o.
00:0002:00000:00002:2020/03/15 07:55:34.55 server Activating disk 'systemdbdev' of size 24576 KB.
00:0002:00000:00002:2020/03/15 07:55:34.80 kernel Initializing virtual device 2, '/opt/sybase/data/sybsysdb.dat' with dsync 'off'.
00:0002:00000:00002:2020/03/15 07:55:34.80 kernel Virtual device 2 started using asynchronous (with DIRECTIO) i/o.
00:0002:00000:00002:2020/03/15 07:55:34.80 server Activating disk 'tempdbdev' of size 332800 KB.
00:0002:00000:00002:2020/03/15 07:55:35.64 kernel Initializing virtual device 3, '/opt/sybase/data/tempdbdev.dat' with dsync 'off'.
00:0002:00000:00002:2020/03/15 07:55:35.64 kernel Virtual device 3 started using asynchronous (with DIRECTIO) i/o.
00:0002:00000:00002:2020/03/15 07:55:35.64 server Activating disk 'sybpcidbdev_data' of size 393216 KB.
00:0002:00000:00002:2020/03/15 07:55:37.75 kernel Initializing virtual device 4, '/opt/sybase/data/sybpcidbdev_data.dat' with dsync 'off'.
00:0002:00000:00002:2020/03/15 07:55:37.76 kernel Virtual device 4 started using asynchronous (with DIRECTIO) i/o.
00:0002:00000:00002:2020/03/15 07:55:38.29 server Recovering database 'sybsystemdb'.
00:0002:00000:00002:2020/03/15 07:55:38.31 server Started estimating recovery log boundaries for database 'sybsystemdb'.
00:0002:00000:00002:2020/03/15 07:55:38.34 server Database 'sybsystemdb', checkpoint=(877, 7), first=(877, 7), last=(877, 7).
00:0002:00000:00002:2020/03/15 07:55:38.34 server Completed estimating recovery log boundaries for database 'sybsystemdb'.
00:0002:00000:00002:2020/03/15 07:55:38.34 server Started ANALYSIS pass for database 'sybsystemdb'.
00:0002:00000:00002:2020/03/15 07:55:38.34 server Completed ANALYSIS pass for database 'sybsystemdb'.
00:0002:00000:00002:2020/03/15 07:55:38.34 server Log contains all committed transactions until 2016/11/17 09:57:29.26 for database sybsystemdb.
00:0002:00000:00002:2020/03/15 07:55:38.34 server Started REDO pass for database 'sybsystemdb'. The total number of log records to process is 1.
00:0002:00000:00002:2020/03/15 07:55:38.43 server Completed REDO pass for database 'sybsystemdb'.
00:0002:00000:00002:2020/03/15 07:55:38.48 server Timestamp for database 'sybsystemdb' is (0x0000, 0x000014f2).
00:0002:00000:00002:2020/03/15 07:55:38.48 server Recovery of database 'sybsystemdb' will undo incomplete nested top actions.
00:0002:00000:00002:2020/03/15 07:55:38.48 server Started recovery checkpoint for database 'sybsystemdb'.
00:0002:00000:00002:2020/03/15 07:55:38.55 server Completed recovery checkpoint for database 'sybsystemdb'.
00:0002:00000:00002:2020/03/15 07:55:38.62 server Started filling free space info for database 'sybsystemdb'.
00:0002:00000:00002:2020/03/15 07:55:38.62 server Completed filling free space info for database 'sybsystemdb'.
00:0002:00000:00002:2020/03/15 07:55:38.64 server Started cleaning up the default data cache for database 'sybsystemdb'.
00:0002:00000:00002:2020/03/15 07:55:38.64 server Completed cleaning up the default data cache for database 'sybsystemdb'.
00:0002:00000:00002:2020/03/15 07:55:38.64 server Boot Count: 4
00:0002:00000:00002:2020/03/15 07:55:38.74 server Checking external objects.
00:0002:00000:00002:2020/03/15 07:55:38.81 server The transaction log in the database 'sybsystemdb' will use I/O size of 16 Kb.
00:0002:00000:00002:2020/03/15 07:55:38.82 server Resident Node id: c67ec619a011
00:0002:00000:00002:2020/03/15 07:55:38.83 server Transaction coordinator initialized.
00:0002:00000:00002:2020/03/15 07:55:38.83 server Database 'sybsystemdb' is now online.
00:0002:00000:00002:2020/03/15 07:55:38.88 server Recovering database 'model'.
00:0002:00000:00002:2020/03/15 07:55:38.90 server Started estimating recovery log boundaries for database 'model'.
00:0002:00000:00002:2020/03/15 07:55:38.93 server Database 'model', checkpoint=(867, 88), first=(867, 88), last=(867, 88).
00:0002:00000:00002:2020/03/15 07:55:38.93 server Completed estimating recovery log boundaries for database 'model'.
00:0002:00000:00002:2020/03/15 07:55:38.93 server Started ANALYSIS pass for database 'model'.
00:0002:00000:00002:2020/03/15 07:55:38.93 server Completed ANALYSIS pass for database 'model'.
00:0002:00000:00002:2020/03/15 07:55:38.93 server Log contains all committed transactions until 2016/11/17 09:57:29.26 for database model.
00:0002:00000:00002:2020/03/15 07:55:38.93 server Started REDO pass for database 'model'. The total number of log records to process is 1.
00:0002:00000:00002:2020/03/15 07:55:38.96 server Completed REDO pass for database 'model'.
00:0002:00000:00002:2020/03/15 07:55:38.98 server Timestamp for database 'model' is (0x0000, 0x0000143c).
00:0002:00000:00002:2020/03/15 07:55:38.98 server Recovery of database 'model' will undo incomplete nested top actions.
00:0002:00000:00002:2020/03/15 07:55:38.98 server Started recovery checkpoint for database 'model'.
00:0002:00000:00002:2020/03/15 07:55:39.05 server Completed recovery checkpoint for database 'model'.
00:0002:00000:00002:2020/03/15 07:55:39.11 server Started filling free space info for database 'model'.
00:0002:00000:00002:2020/03/15 07:55:39.11 server Completed filling free space info for database 'model'.
00:0002:00000:00002:2020/03/15 07:55:39.13 server Started cleaning up the default data cache for database 'model'.
00:0002:00000:00002:2020/03/15 07:55:39.13 server Completed cleaning up the default data cache for database 'model'.
00:0002:00000:00002:2020/03/15 07:55:39.18 server Checking external objects.
00:0002:00000:00002:2020/03/15 07:55:39.26 server The transaction log in the database 'model' will use I/O size of 16 Kb.
00:0002:00000:00002:2020/03/15 07:55:39.27 server Database 'model' is now online.
00:0002:00000:00002:2020/03/15 07:55:39.27 server The logical pagesize of the server is 16 Kb.
00:0002:00000:00002:2020/03/15 07:55:39.27 server 0 dump conditions detected at boot time
00:0002:00000:00002:2020/03/15 07:55:39.29 server Clearing temporary database 'tempdb'.
00:0002:00000:00002:2020/03/15 07:55:41.76 server Tempdb 2 is added to the list of local temporary databases
00:0002:00000:00002:2020/03/15 07:55:41.89 server Timestamp for database 'tempdb' is (0x0000, 0x0000143c).
00:0002:00000:00002:2020/03/15 07:55:42.53 server Checking external objects.
00:0002:00000:00002:2020/03/15 07:55:42.62 server The transaction log in the database 'tempdb' will use I/O size of 16 Kb.
00:0002:00000:00002:2020/03/15 07:55:42.64 server Database 'tempdb' is now online.
00:0002:00000:00002:2020/03/15 07:55:42.71 server Recovering database 'sybsystemprocs'.
00:0002:00000:00002:2020/03/15 07:55:42.74 server Started estimating recovery log boundaries for database 'sybsystemprocs'.
00:0002:00000:00002:2020/03/15 07:55:42.82 server Database 'sybsystemprocs', checkpoint=(9022, 60), first=(9022, 60), last=(9022, 60).
00:0002:00000:00002:2020/03/15 07:55:42.82 server Completed estimating recovery log boundaries for database 'sybsystemprocs'.
00:0002:00000:00002:2020/03/15 07:55:42.82 server Started ANALYSIS pass for database 'sybsystemprocs'.
00:0002:00000:00002:2020/03/15 07:55:42.82 server Completed ANALYSIS pass for database 'sybsystemprocs'.
00:0002:00000:00002:2020/03/15 07:55:42.82 server Log contains all committed transactions until 2016/11/17 09:57:29.26 for database sybsystemprocs.
00:0002:00000:00002:2020/03/15 07:55:42.82 server Started REDO pass for database 'sybsystemprocs'. The total number of log records to process is 1.
00:0002:00000:00002:2020/03/15 07:55:42.85 server Completed REDO pass for database 'sybsystemprocs'.
00:0002:00000:00002:2020/03/15 07:55:43.08 server Timestamp for database 'sybsystemprocs' is (0x0000, 0x0004816b).
00:0002:00000:00002:2020/03/15 07:55:43.08 server Recovery of database 'sybsystemprocs' will undo incomplete nested top actions.
00:0002:00000:00002:2020/03/15 07:55:43.09 server Started recovery checkpoint for database 'sybsystemprocs'.
00:0002:00000:00002:2020/03/15 07:55:43.16 server Completed recovery checkpoint for database 'sybsystemprocs'.
00:0002:00000:00002:2020/03/15 07:55:43.22 server Started filling free space info for database 'sybsystemprocs'.
00:0002:00000:00002:2020/03/15 07:55:43.23 server Completed filling free space info for database 'sybsystemprocs'.
00:0002:00000:00002:2020/03/15 07:55:43.26 server Started cleaning up the default data cache for database 'sybsystemprocs'.
00:0002:00000:00002:2020/03/15 07:55:43.26 server Completed cleaning up the default data cache for database 'sybsystemprocs'.
00:0002:00000:00002:2020/03/15 07:55:43.31 server Checking external objects.
00:0002:00000:00002:2020/03/15 07:55:43.47 server The transaction log in the database 'sybsystemprocs' will use I/O size of 16 Kb.
00:0002:00000:00002:2020/03/15 07:55:43.49 server Database 'sybsystemprocs' is now online.
00:0002:00000:00010:2020/03/15 07:55:43.66 kernel network name 0.0.0.0, interface IPv4, address 0.0.0.0, type tcp, port 5000, filter NONE
00:0002:00000:00002:2020/03/15 07:55:44.08 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:00002:2020/03/15 07:55:44.08 server The server will recover databases serially.
00:0002:00000:00002:2020/03/15 07:55:44.16 server Recovering database 'sybpcidb'.
00:0002:00000:00002:2020/03/15 07:55:44.18 server Started estimating recovery log boundaries for database 'sybpcidb'.
00:0002:00000:00002:2020/03/15 07:55:44.21 server Database 'sybpcidb', checkpoint=(1936, 53), first=(1936, 53), last=(1936, 53).
00:0002:00000:00002:2020/03/15 07:55:44.21 server Completed estimating recovery log boundaries for database 'sybpcidb'.
00:0002:00000:00002:2020/03/15 07:55:44.21 server Started ANALYSIS pass for database 'sybpcidb'.
00:0002:00000:00002:2020/03/15 07:55:44.21 server Completed ANALYSIS pass for database 'sybpcidb'.
00:0002:00000:00002:2020/03/15 07:55:44.21 server Log contains all committed transactions until 2016/11/17 09:57:29.26 for database sybpcidb.
00:0002:00000:00002:2020/03/15 07:55:44.21 server Started REDO pass for database 'sybpcidb'. The total number of log records to process is 1.
00:0002:00000:00002:2020/03/15 07:55:44.26 server Completed REDO pass for database 'sybpcidb'.
00:0002:00000:00002:2020/03/15 07:55:46.00 server Timestamp for database 'sybpcidb' is (0x0000, 0x00006c46).
00:0002:00000:00002:2020/03/15 07:55:46.00 server Recovery of database 'sybpcidb' will undo incomplete nested top actions.
00:0002:00000:00002:2020/03/15 07:55:46.02 server Started recovery checkpoint for database 'sybpcidb'.
00:0002:00000:00002:2020/03/15 07:55:46.09 server Completed recovery checkpoint for database 'sybpcidb'.
00:0002:00000:00002:2020/03/15 07:55:46.15 server Started filling free space info for database 'sybpcidb'.
00:0002:00000:00002:2020/03/15 07:55:46.16 server Completed filling free space info for database 'sybpcidb'.
00:0002:00000:00002:2020/03/15 07:55:46.18 server Started cleaning up the default data cache for database 'sybpcidb'.
00:0002:00000:00002:2020/03/15 07:55:46.18 server Completed cleaning up the default data cache for database 'sybpcidb'.
00:0002:00000:00002:2020/03/15 07:55:46.26 server Checking external objects.
00:0002:00000:00002:2020/03/15 07:55:46.46 server The transaction log in the database 'sybpcidb' will use I/O size of 16 Kb.
00:0002:00000:00002:2020/03/15 07:55:46.48 server Database 'sybpcidb' is now online.
00:0002:00000:00002:2020/03/15 07:55:46.48 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:00002:2020/03/15 07:55:46.53 server Recovery complete.
00:0002:00000:00002:2020/03/15 07:55:46.53 server ASE's default unicode sort order is 'binary'.
00:0002:00000:00002:2020/03/15 07:55:46.53 server ASE's default sort order is:
00:0002:00000:00002:2020/03/15 07:55:46.53 server 'bin_iso_1' (ID = 50)
00:0002:00000:00002:2020/03/15 07:55:46.53 server on top of default character set:
00:0002:00000:00002:2020/03/15 07:55:46.53 server 'iso_1' (ID = 1).
00:0002:00000:00002:2020/03/15 07:55:46.54 kernel PCI(M1): PCI Bridge Config: Starting dynamic PCI Bridge configuration.
00:0002:00000:00002:2020/03/15 07:55:46.55 kernel PCI(M1): PCI Bridge Config: Checking for PLB configuration options.
00:0002:00000:00002:2020/03/15 07:55:47.16 kernel PCI(M1): PCI Bridge Config: Reconfigured 'PCI scheduling' signal driven.
00:0002:00000:00002:2020/03/15 07:55:47.16 kernel PCI(M1): PCI Bridge Config: Engine failover is set to automatic
00:0002:00000:00002:2020/03/15 07:55:47.16 kernel PCI(M1): PCI Bridge Config: Reconfigured the maximum number of threads to 1056
00:0002:00000:00002:2020/03/15 07:55:47.16 kernel PCI(M1): PCI Bridge Config: Runtime escape allocator is set to : 1 (enabled)
00:0002:00000:00002:2020/03/15 07:55:47.16 kernel PCI(M1): PCI Bridge: 'slotring' forced wash cycle has been disabled
00:0002:00000:00002:2020/03/15 07:55:47.16 kernel PCI(M1): PCI Bridge Config: Reconfigured 'slotring' washing cycle to 0 (disabled)
00:0002:00000:00002:2020/03/15 07:55:47.16 kernel PCI(M1): PCI Bridge Config: Reconfigured 'slotring' washing threshold to 76 (percent).
00:0002:00000:00002:2020/03/15 07:55:47.16 kernel PCI(M1): PCI Bridge: 'slotring' wash threshold has been changed to: 76 (percent)
00:0002:00000:00002:2020/03/15 07:55:47.16 kernel PCI(M1): PCI Bridge Config: Checking for log options.
00:0002:00000:00002:2020/03/15 07:55:47.17 kernel PCI(M1): PCI Bridge Config: Checking for instrumentation options.
00:0002:00000:00002:2020/03/15 07:55:47.17 kernel PCI(M1): PCI Bridge Config: Switched on : Force all fetch_classdata hits to Report
00:0002:00000:00002:2020/03/15 07:55:47.17 kernel PCI(M1): PCI Bridge Config: Finished dynamic PCI Bridge configuration.
00:0002:00000:00002:2020/03/15 07:55:47.17 kernel PCI(M1): PCI Bridge Config: Start the DPRT setup for : JVM
00:0002:00000:00002:2020/03/15 07:55:47.18 kernel PCI(M1): PCI Bridge Config: Finished the DPRT setup for : JVM
00:0002:00000:00002:2020/03/15 07:55:47.20 kernel PCI(M1): Loading PCA version: SAP JVM/16.0 SP02 PL02/EBF 25320 SMP/P/x86_64/Enterprise Linux/ase160sp02plx/2492/64-bit/OPT/Sat Nov 21 02:29:37 2015
00:0002:00000:00002:2020/03/15 07:55:47.20 kernel PCI(M1): PCA JVM Config: Starting dynamic PCA JVM configuration
00:0002:00000:00002:2020/03/15 07:55:47.20 kernel PCI(M1): PCA JVM Config: VM configuration has been successfully created
00:0002:00000:00002:2020/03/15 07:55:47.20 kernel PCI(M1): PCA JVM Config: Reading PCA/JVM Configuration Options
00:0002:00000:00002:2020/03/15 07:55:47.20 kernel PCI(M1): PCA JVM Config: Reading Directory definitions
00:0002:00000:00002:2020/03/15 07:55:47.21 kernel PCI(M1): PCA JVM Config: Reading JRE/VM Work dir settings
00:0002:00000:00002:2020/03/15 07:55:47.21 kernel PCI(M1): PCA JVM Config: Reading System Device Path directories
00:0002:00000:00002:2020/03/15 07:55:47.21 kernel PCI(M1): PCA JVM Config: Reading Minimum JNI Version
00:0002:00000:00002:2020/03/15 07:55:47.22 kernel PCI(M1): PCA JVM Config: Reading JVM Client path
00:0002:00000:00002:2020/03/15 07:55:47.22 kernel PCI(M1): PCA JVM Config: Reading JRE/VM Verbose Logging Options
00:0002:00000:00002:2020/03/15 07:55:47.22 kernel PCI(M1): PCA JVM Config: Reading Extension Class Loading Options
00:0002:00000:00002:2020/03/15 07:55:47.22 kernel PCI(M1): PCA JVM Config: Reading JAVA Startup Options
00:0002:00000:00002:2020/03/15 07:55:47.22 kernel PCI(M1): PCA JVM Config: Reading JAVA Debug Agent Configuration
00:0002:00000:00002:2020/03/15 07:55:47.23 kernel PCI(M1): PCA JVM Config: All property options have been read from sybpcidb
00:0002:00000:00002:2020/03/15 07:55:47.23 kernel PCI(M1): PCA JVM Config: Validating configuration...
00:0002:00000:00002:2020/03/15 07:55:47.23 kernel PCI(M1): Validation Warning: Property: TMP_DIR has not been initialized so File I/O functionality will be disabled and unavailable
00:0002:00000:00002:2020/03/15 07:55:47.23 kernel PCI(M1): PCA JVM Config: Validation Successful
00:0002:00000:00002:2020/03/15 07:55:47.23 kernel PCI(M1): PCI Bridge Config: Finished the configuration for : JVM on slot : 1
00:0002:00000:00002:2020/03/15 07:55:47.23 kernel PCI(M1): PCI Bridge Config: Start the DPRT setup for : ODBC
00:0002:00000:00002:2020/03/15 07:55:47.23 kernel PCI(M1): PCI Bridge Config: Finished the DPRT setup for : ODBC
00:0002:00000:00002:2020/03/15 07:55:47.23 kernel PCI(M1): Loading PCA version: ODBC Adaptor/16.0 SP02 PL02/EBF 25320 SMP/P/x86_64/Enterprise Linux/ase160sp02plx/2492/64-bit/OPT/Sat Nov 21 02:29:37 2015
00:0002:00000:00002:2020/03/15 07:55:47.23 kernel PCI(M1): PCA ODBC Config: Starting dynamic PCA ODBC configuration
00:0002:00000:00002:2020/03/15 07:55:47.23 kernel PCI(M1): PCA ODBC Config: Module configuration has been successfully created
00:0002:00000:00002:2020/03/15 07:55:47.23 kernel PCI(M1): PCA ODBC Config: Reading PCA/ODBC Configuration Options
00:0002:00000:00002:2020/03/15 07:55:47.24 kernel PCI(M1): PCA ODBC Config: Reading Directory definitions
00:0002:00000:00002:2020/03/15 07:55:47.24 kernel PCI(M1): PCA ODBC Config: Reading ODBC Driver Manager dir settings
00:0002:00000:00002:2020/03/15 07:55:47.24 kernel PCI(M1): PCA ODBC Config: Reading ODBC Driver Manager Modulepath
00:0002:00000:00002:2020/03/15 07:55:47.24 kernel PCI(M1): PCA ODBC Config: Reading ODBC Driver Manager Options
00:0002:00000:00002:2020/03/15 07:55:47.24 kernel PCI(M1): PCA ODBC Config: All property options have been read from sybpcidb
00:0002:00000:00002:2020/03/15 07:55:47.24 kernel PCI(M1): PCA ODBC Config: Validating configuration...
00:0002:00000:00002:2020/03/15 07:55:47.24 kernel PCI(M1): PCA ODBC Config: Validation Successful
00:0002:00000:00002:2020/03/15 07:55:47.24 kernel PCI(M1): PCI Bridge Config: Finished the configuration for : ODBC on slot : 2
00:0002:00000:00002:2020/03/15 07:55:47.24 server Master device size: 384 megabytes, or 196608 virtual pages. (A virtual page is 2048 bytes.)
00:0002:00000:00002:2020/03/15 07:55:47.30 kernel Warning: Cannot set console to nonblocking mode, switching to blocking mode.
00:0002:00000:00002:2020/03/15 07:55:47.30 kernel Console logging is disabled. This is controlled via the 'enable console logging' configuration parameter.
[이 글에 대해서 여러분들과 의견을 공유하고 싶습니다. 틀리거나 미흡한 부분 또는 의문 사항이 있으시면 언제든 댓글 남겨주십시오.]