성태의 닷넷 이야기
홈 주인
모아 놓은 자료
프로그래밍
질문/답변
사용자 관리
사용자
메뉴
아티클
외부 아티클
유용한 코드
온라인 기능
MathJax 입력기
최근 덧글
[정성태] 아쉽게도, 커뮤니티는 아니고 개인 블로그입니다. ^^
[정성태] 질문이 잘 이해가 안 됩니다. 우선, 해당 소스코드에서 ILis...
[양승조
] var대신 dinamic으로 선언해서 해결은 했습니다. 맞는 해...
[양승조
] 또 막혔습니다. ㅠㅠ var list = props[i].Ge...
[양승조
] 아. 감사합니다. 어제는 안됐던것 같은데....정신을 차려야겠네...
[정성태] "props[i].GetValue(props[i])" 코드에서 ...
[정성태] 저렇게 조각 코드 말고, 실제로 재현이 되는 예제 프로젝트를 압...
[정성태] Modules 창(Ctrl+Shift+U)을 띄워서, 해당 Op...
[정성태] 만드실 수 있습니다. 단지, Unity 엔진 내의 스크립트와 W...
[공진영] 안녕하세요 좋은글 감사합니다. 현재 제가 wpf로 관제 모...
글쓰기
제목
이름
암호
전자우편
HTML
홈페이지
유형
제니퍼 .NET
닷넷
COM 개체 관련
스크립트
VC++
VS.NET IDE
Windows
Team Foundation Server
디버깅 기술
오류 유형
개발 환경 구성
웹
기타
Linux
Java
DDK
Math
Phone
Graphics
사물인터넷
부모글 보이기/감추기
내용
<div style='display: inline'> <h1 style='font-family: Malgun Gothic, Consolas; font-size: 20pt; color: #006699; text-align: center; font-weight: bold'>docker - SAP Adaptive Server Enterprise 컨테이너 실행</h1> <p> SAP ASE 제품도 현재 공식 이미지는 제공되지 않습니다. 그래서 다음의 이미지를 사용해 볼 텐데,<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > nguoianphu/docker-sybase ; <a target='tab' href='https://hub.docker.com/r/nguoianphu/docker-sybase'>https://hub.docker.com/r/nguoianphu/docker-sybase</a> </pre> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > 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 </pre> <br /> 다음의 계정과 서버 인스턴스로 미리 설정되어 있습니다.<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > USER: sa PASSWORD: myPassword Server: MYSYBASE </pre> <br /> 그런데... 아쉽게도 공식적인 GUI 클라이언트가 없습니다. (혹시 쓸만한 GUI 도구를 아시는 분은 덧글 부탁드립니다. ^^)<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > Where is PC Client for ASE? ; <a target='tab' href='https://archive.sap.com/documents/docs/DOC-56188'>https://archive.sap.com/documents/docs/DOC-56188</a> 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. </pre> <br /> 대신 해당 컨테이너에 포함된 isql 명령행 인터페이스를 실행해 볼 수 있는데, 편의성을 위해 "/opt/sybase/SYBASE.sh" 파일에 대해 source 명령어를 실행 후 구동할 수 있습니다.<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > c:\temp&gt; <span style='color: blue; font-weight: bold'>docker exec -it ase16 /bin/bash</span> [root@68e80d681ccd bin]# <span style='color: blue; font-weight: bold'>source /opt/sybase/SYBASE.sh</span> [root@68e80d681ccd /]# find / -name isql /opt/sybase/OCS-16_0/bin/isql [root@68e80d681ccd /]# <span style='color: blue; font-weight: bold'>isql -U sa -P myPassword -S MYSYBASE</span> 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) </pre> <br /> 또는 원격에서 접속하는 경우라면 "-S" 옵션에 IP와 포트를 함께 지정하면 됩니다.<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > c:\SAP\OCS-16_0\bin> <span style='color: blue; font-weight: bold'>isql -U sa -P myPassword -S 192.168.100.50:5000</span> 1> </pre> <br /> 마지막으로 데이터베이스 유지를 위한 볼륨은 /opt/sybase/data로 연결하면 되고.<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > c:\temp&gt; docker run --name ase16 <span style='color: blue; font-weight: bold'>-v ase16:/opt/sybase/data</span> -p 5000:5000 -p 5001:5001 nguoianphu/docker-sybase </pre> <br /> <hr style='width: 50%' /><br /> <br /> isql 내에서의 명령은 다음의 문서를 참조하면 됩니다.<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > SAP Adaptive Server Enterprise 16.0 > Reference Manual: Commands 16.0 ; <a target='tab' href='http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc36272.1600/doc/html/san1393050880067.html'>http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc36272.1600/doc/html/san1393050880067.html</a> </pre> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > SYBASE 기본 사용법(시작/종료, Login/Logout, DB생성/삭제/변경, Device등록/삭제, ; <a target='tab' href='http://pchero21.com/?p=990'>http://pchero21.com/?p=990</a> </pre> <br /> 아래는 기본적인 동작 몇 가지를 수행한 것입니다.<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > 1> <span style='color: blue; font-weight: bold'>sp_helpdb</span> 2> <span style='color: blue; font-weight: bold'>go</span> 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> <span style='color: blue; font-weight: bold'>select db_name()</span> 2> <span style='color: blue; font-weight: bold'>go</span> ------------------------------ master (1 row affected) 1> <span style='color: blue; font-weight: bold'>disk init name="testdb_dev", physname="/opt/sybase/data/testdb.dat", size="60M"</span> 2> <span style='color: blue; font-weight: bold'>go</span> 1> <span style='color: blue; font-weight: bold'>create database testdb on testdb_dev</span> 2> <span style='color: blue; font-weight: bold'>go</span> CREATE DATABASE: allocating 1536 logical pages (24.0 megabytes) on disk 'testdb_dev' (1536 logical pages requested). Database 'testdb' is now online. 1> <span style='color: blue; font-weight: bold'>use testdb</span> 2> <span style='color: blue; font-weight: bold'>go</span> 1> <span style='color: blue; font-weight: bold'>select db_name()</span> 2> <span style='color: blue; font-weight: bold'>go</span> ------------------------------ testdb (1 row affected) 1> <span style='color: blue; font-weight: bold'>create table foo (a int, b int default @@spid)</span> 2> <span style='color: blue; font-weight: bold'>go</span> 1> <span style='color: blue; font-weight: bold'>create table testtable (PersonID int not null unique, FirstName varchar (50), LastName varchar (50), Address varchar (150), City varchar (50))</span> 2> <span style='color: blue; font-weight: bold'>go</span> </pre> <br /> 이런 식으로 데이터베이스와 테이블을 구성했으면 ADO.NET을 이용해 개발을 진행하면 됩니다. ^^<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > 닷넷에서 SAP Adaptive Server Enterprise 데이터베이스 사용 ; <a target='tab' href='https://www.sysnet.pe.kr/2/0/10884'>https://www.sysnet.pe.kr/2/0/10884</a> </pre> <br /> <hr style='width: 50%' /><br /> <br /> 참고로, 다음은 정상적으로 실행된 경우 출력되는 로그입니다.<br /> <br /> <pre style='height: 400px; margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > C:\temp> <span style='color: blue; font-weight: bold'>docker run --name ase16 -p 5000:5000 -p 5001:5001 nguoianphu/docker-sybase</span> 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. </pre> </p><br /> <br /><hr /><span style='color: Maroon'>[이 글에 대해서 여러분들과 의견을 공유하고 싶습니다. 틀리거나 미흡한 부분 또는 의문 사항이 있으시면 언제든 댓글 남겨주십시오.]</span> </div>
첨부파일
스팸 방지용 인증 번호
3120
(왼쪽의 숫자를 입력해야 합니다.)