Documentum CM 25.4 설치

MS-SQL

SQL Server Management Studio와 SQL Server 클라이언트를 설치
원격 SQL Server -> SQL Server 클라이언트 패키지를 반드시 설치
set the database code page, case-sensitivity
SQL Server 설정:
PARAMETERIZATION=FORCED
Allow Snapshot Isolation = ON
READ_COMMITTED_SNAPSHOT = ON

USE [master]
GO

/****** Object:  Database [dm_EDMS_docbase]    Script Date: 2023-03-08 오후 5:29:17 ******/
DROP DATABASE [dm_EDMS_docbase]
GO

/****** Object:  Database [dm_EDMS_docbase]    Script Date: 2023-03-08 오후 5:29:17 ******/
CREATE DATABASE [dm_EDMS_docbase]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'dm_EDMS_docbase', FILENAME = N'D:\Microsoft SQL Server\DATA\dm_EDMS_data1.mdf' , SIZE = 184320KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB )
 LOG ON 
( NAME = N'dm_EDMS_log', FILENAME = N'D:\Microsoft SQL Server\DATA\dm_EDMS_log1.ldf' , SIZE = 55296KB , MAXSIZE = 2048GB , FILEGROWTH = 10240KB )
 WITH CATALOG_COLLATION = DATABASE_DEFAULT
GO

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [dm_EDMS_docbase].[dbo].[sp_fulltext_database] @action = 'enable'
end


ALTER DATABASE [dm_EDMS_docbase] COLLATE Korean_Wansung_CS_AS
GO

ALTER DATABASE [dm_EDMS_docbase] SET ANSI_NULL_DEFAULT OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET ANSI_NULLS OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET ANSI_PADDING OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET ANSI_WARNINGS OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET ARITHABORT OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET AUTO_CLOSE OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET AUTO_SHRINK OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET AUTO_UPDATE_STATISTICS ON 
GO

ALTER DATABASE [dm_EDMS_docbase] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET CURSOR_DEFAULT  GLOBAL 
GO

ALTER DATABASE [dm_EDMS_docbase] SET CONCAT_NULL_YIELDS_NULL OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET NUMERIC_ROUNDABORT OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET QUOTED_IDENTIFIER OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET RECURSIVE_TRIGGERS OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET  ENABLE_BROKER 
GO

ALTER DATABASE [dm_EDMS_docbase] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET TRUSTWORTHY OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET PARAMETERIZATION SIMPLE 
GO

ALTER DATABASE [dm_EDMS_docbase] SET READ_COMMITTED_SNAPSHOT ON 
GO

ALTER DATABASE [dm_EDMS_docbase] SET HONOR_BROKER_PRIORITY OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET RECOVERY FULL 
GO

ALTER DATABASE [dm_EDMS_docbase] SET  MULTI_USER 
GO

ALTER DATABASE [dm_EDMS_docbase] SET PAGE_VERIFY CHECKSUM  
GO

ALTER DATABASE [dm_EDMS_docbase] SET DB_CHAINING OFF 
GO

ALTER DATABASE [dm_EDMS_docbase] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO

ALTER DATABASE [dm_EDMS_docbase] SET TARGET_RECOVERY_TIME = 60 SECONDS 
GO

ALTER DATABASE [dm_EDMS_docbase] SET DELAYED_DURABILITY = DISABLED 
GO

ALTER DATABASE [dm_EDMS_docbase] SET ACCELERATED_DATABASE_RECOVERY = OFF  
GO

ALTER DATABASE [dm_EDMS_docbase] SET QUERY_STORE = OFF
GO

ALTER DATABASE [dm_EDMS_docbase] SET  READ_WRITE 
GO

USE [master]
GO

/****** Object:  Login [dmdbowner]    Script Date: 2023-03-08 오후 5:30:51 ******/
DROP LOGIN [dmdbowner]
GO

CREATE LOGIN [dmdbowner] WITH PASSWORD=N'Opentext1@', DEFAULT_DATABASE=[dm_EDMS_docbase], DEFAULT_LANGUAGE=[한국어], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
GO
/****** 관리툴에서 비번 바꿔야함 ******/

ALTER LOGIN [dmdbowner] ENABLE
GO

USE [dm_EDMS_docbase]
GO
EXEC sp_changedbowner 'dmdbowner'
GO

64비트 ODBC 데이터 소스(오직 SQL Server 드라이버 사용, Native Client 드라이버는 지원하지 않음)
User DSN 탭 사용 가능
sqlcmd 유틸리티를 설치해야 합니다.
case-sensitive, row-level locking(기본)이 활성화된 상태로 설치

설치 실패시 삭제 스크립트

USE master;
GO

-- 1. 데이터베이스 강제 삭제 (접속자 다 끊고 삭제)
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'dm_EDMS_docbase')
BEGIN
    ALTER DATABASE [dm_EDMS_docbase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
    DROP DATABASE [dm_EDMS_docbase];
    PRINT 'Database [dm_EDMS_docbase] deleted.';
END
GO

-- 2. master DB에 등록된 사용자(User) 삭제
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'dmdbowner')
BEGIN
    DROP USER [dmdbowner];
    PRINT 'User [dmdbowner] removed from master.';
END
GO

-- 3. 서버 레벨 로그인(Login) 계정 삭제
IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'dmdbowner')
BEGIN
    DROP LOGIN [dmdbowner];
    PRINT 'Login [dmdbowner] deleted from server.';
END
GO

PRINT '--- Cleanup Complete. Now you can run the installer. ---';

windows

Pre-installation tasks on Windows

a four-digit year (yyyy) date <이미 되어 있음> Disable the user access control (UAC). Disable the IP Helper service from the Windows Services console Install Microsoft Visual C++ 2013 and 2019 Redistributable (64-bit) packages before creating a repository. <이미 되어 있음>

IPV6 끄기 (옵션)

위치: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip6\Parameters\ 이름: DisabledComponents 유형: REG_DWORD 값 : 10진수 32

네트워크 우선순위 변경

고급 TCP/IP설정 자동메트릭 인터페이스 메트릭스 1 로 설정

JAVA설치

SET JAVA_HOME=D:\JDK\jdk-11.0.16 SET PATH=%JAVA_HOME%\bin

minimum password length

env 설정

DM_CRYPTO_MIN_PASSWORD_LENGTH = 8

append,c,docbaseconfig,r_module_name
DM_CRYPTO_MIN_PASSWORD_LENGTH
append,c,docbaseconfig,r_module_mode
<desired value> //for example, 10
save,c,docbaseconfig
reinit,c