Microsoft MVP성태의 닷넷 이야기
글쓴 사람
홈페이지
첨부 파일
 

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)
12217정성태5/24/202016오류 유형: 615. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
12216정성태5/15/202077.NET Framework: 904. USB/IP PROJECT를 이용해 C#으로 USB Keyboard 가상 장치 만들기
12215정성태5/12/202097개발 환경 구성: 490. C# - (Wireshark의) USBPcap을 이용한 USB 패킷 모니터링파일 다운로드1
12214정성태5/5/202089개발 환경 구성: 489. 정식 인증서가 있는 경우 Device Driver 서명하는 방법 (2) - UEFI/SecureBoot
12213정성태5/3/2020177개발 환경 구성: 488. (코드로 가상 USB 장치를 만들 수 있는) USB/IP PROJECT 소개
12212정성태5/1/202087개발 환경 구성: 487. UEFI / Secure Boot 상태인지 확인하는 방법
12211정성태4/27/2020187개발 환경 구성: 486. WSL에서 Makefile로 공개된 리눅스 환경의 C/C++ 소스 코드 빌드
12210정성태4/20/2020292.NET Framework: 903. .NET Framework의 Strong-named 어셈블리 바인딩 (1) - app.config을 이용한 바인딩 리디렉션 [1]파일 다운로드1
12209정성태4/13/2020160오류 유형: 614. 리눅스 환경에서 C/C++ 프로그램이 Segmentation fault 에러가 발생한 경우 (2)
12208정성태4/12/2020187Linux: 29. 리눅스 환경에서 C/C++ 프로그램이 Segmentation fault 에러가 발생한 경우
12207정성태4/2/2020179스크립트: 19. Windows PowerShell의 NonInteractive 모드
12206정성태4/2/2020259오류 유형: 613. 파일 잠금이 바로 안 풀린다면? - The process cannot access the file '...' because it is being used by another process.
12205정성태4/2/2020157스크립트: 18. Powershell에서는 cmd.exe의 명령어를 지원하진 않습니다.
12204정성태4/1/2020158스크립트: 17. Powershell 명령어에 ';' (semi-colon) 문자가 포함된 경우
12203정성태3/18/2020352오류 유형: 612. warning: 'C:\ProgramData/Git/config' has a dubious owner: '...'.
12202정성태3/18/2020348개발 환경 구성: 486. .NET Framework 프로젝트를 위한 GitLab CI/CD Runner 구성
12201정성태3/18/2020184오류 유형: 611. git-credential-manager.exe: Using credentials for username "Personal Access Token".
12200정성태3/18/2020438VS.NET IDE: 145. NuGet + Github 라이브러리 디버깅 관련 옵션 3가지 - "Enable Just My Code" / "Enable Source Link support" / "Suppress JIT optimization on module load (Managed only)"
12199정성태3/17/2020176오류 유형: 610. C# - CodeDomProvider 사용 시 Unhandled Exception: System.IO.DirectoryNotFoundException: Could not find a part of the path '...\f2_6uod0.tmp'.
12198정성태3/17/2020187오류 유형: 609. SQL 서버 접속 시 "Cannot open user default database. Login failed."
12197정성태3/17/2020295VS.NET IDE: 144. .NET Core 콘솔 응용 프로그램을 배포(publish) 시 docker image 자동 생성 - 두 번째 이야기
12196정성태3/17/2020266오류 유형: 608. The ServicedComponent being invoked is not correctly configured (Use regsvcs to re-register).
12195정성태3/17/2020368.NET Framework: 902. C# - 프로세스의 모든 핸들을 열람 - 세 번째 이야기
12194정성태3/16/2020216오류 유형: 607. PostgreSQL - Npgsql.NpgsqlException: sorry, too many clients already
12193정성태3/16/2020240개발 환경 구성: 485. docker - SAP Adaptive Server Enterprise 컨테이너 실행
[1]  2  3  4  5  6  7  8  9  10  11  12  13  14  15  ...