Microsoft MVP성태의 닷넷 이야기
글쓴 사람
정성태 (techsharer at outlook.com)
홈페이지
첨부 파일
 

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.




[이 글에 대해서 여러분들과 의견을 공유하고 싶습니다. 틀리거나 미흡한 부분 또는 의문 사항이 있으시면 언제든 댓글 남겨주십시오.]





[최초 등록일: ]
[최종 수정일: 3/16/2020 ]

Creative Commons License
이 저작물은 크리에이티브 커먼즈 코리아 저작자표시-비영리-변경금지 2.0 대한민국 라이센스에 따라 이용하실 수 있습니다.
by SeongTae Jeong, mailto:techsharer@outlook.com

비밀번호

댓글 쓴 사람
 




[1]  2  3  4  5  6  7  8  9  10  11  12  13  14  15  ...
NoWriterDateCnt.TitleFile(s)
12333정성태9/20/202048.NET Framework: 941. C# - 전위/후위 증감 연산자에 대한 오버로딩 구현 (2)
12332정성태9/18/202040.NET Framework: 940. C# - Windows Forms ListView와 DataGridView의 예제 코드파일 다운로드1
12331정성태9/18/202039오류 유형: 651. repadmin /syncall - 0x80090322 The target principal name is incorrect.
12330정성태9/20/2020135.NET Framework: 939. C# - 전위/후위 증감 연산자에 대한 오버로딩 구현 [2]파일 다운로드1
12329정성태9/16/202060오류 유형: 650. ASUS 메인보드 관련 소프트웨어 설치 후 ArmouryCrate.UserSessionHelper.exe 프로세스 무한 종료 현상
12328정성태9/16/202046VS.NET IDE: 150. TFS의 이력에서 "Get This Version"과 같은 기능을 Git으로 처리한다면?
12327정성태9/12/2020104.NET Framework: 938. C# - ICS(Internet Connection Sharing) 제어파일 다운로드1
12326정성태9/12/202099개발 환경 구성: 516. Azure VM의 Network Adapter를 실수로 비활성화한 경우
12325정성태9/12/202090개발 환경 구성: 515. OpenVPN - 재부팅 후 ICS(Internet Connection Sharing) 기능이 동작 안하는 문제
12324정성태9/11/2020137개발 환경 구성: 514. smigdeploy.exe를 이용한 Windows Server 2016에서 2019로 마이그레이션 방법
12323정성태9/11/2020119오류 유형: 649. Copy Database Wizard - The job failed. Check the event log on the destination server for details.
12322정성태9/11/2020140개발 환경 구성: 513. Azure VM의 RDP 접속 위치 제한
12321정성태9/11/2020118오류 유형: 648. netsh http add urlacl - Error: 183 Cannot create a file when that file already exists.
12320정성태9/11/2020169개발 환경 구성: 512. RDP(원격 데스크톱) 접속 시 비밀 번호를 한 번 더 입력해야 하는 경우
12319정성태9/10/2020130오류 유형: 647. smigdeploy.exe를 Windows Server 2016에서 실행할 때 .NET Framework 미설치 오류 발생
12318정성태9/9/2020129오류 유형: 646. OpenVPN - "TAP-Windows Adapter V9" 어댑터의 "Network cable unplugged" 현상
12317정성태9/10/2020131개발 환경 구성: 511. Beats 용 Kibana 기본 대시 보드 구성 방법
12316정성태9/8/2020296디버깅 기술: 170. WinDbg Preview 버전부터 닷넷 코어 3.0 이후의 메모리 덤프에 대해 sos.dll 자동 로드
12315정성태9/7/2020237개발 환경 구성: 510. Logstash - FileBeat을 이용한 IIS 로그 처리 [2]
12314정성태9/7/2020160오류 유형: 645. IIS HTTPERR - Timer_MinBytesPerSecond, Timer_ConnectionIdle 로그
12313정성태9/7/2020307개발 환경 구성: 509. Logstash - 사용자 정의 grok 패턴 추가를 이용한 IIS 로그 처리
12312정성태9/5/2020244개발 환경 구성: 508. Logstash 기본 사용법
12311정성태9/4/2020363.NET Framework: 937. C# - 간단하게 만들어 보는 리눅스의 nc(netcat) 프로그램
12310정성태9/3/2020159오류 유형: 644. Windows could not start the Elasticsearch 7.9.0 (elasticsearch-service-x64) service on Local Computer.
12309정성태9/3/2020209개발 환경 구성: 507. Elasticsearch 6.6부터 기본 추가된 한글 형태소 분석기 노리(nori) 사용법
[1]  2  3  4  5  6  7  8  9  10  11  12  13  14  15  ...