EMC HVS(High Volume Server) 성능 테스트

EMC HVS(High Volume Server) 시스템 테스트 시나리오

Test 항목 : HVS를 이용한 등록 (엔진)

1.    실시 회사 : (XXXX: Documentum Server 6.5sp1)

1.1          HVS(High Volume Server)를 이용한 이미지 등록

구분	HVS 기능	Data 등록건수		적용 유무	소요시간/DB Size
		DB	Imae
Injection Speed	Batch	1만	1만	Ｘ	342297 millisecond = 5분 7초
				Ｏ	225922 millisecond = 3분 8초
		5만	5만	Ｘ	2240312 millisecond = 37분 3초
				Ｏ	1260250 millisecond = 21분
	Scope
	Batch + Scope
DB Size	Lightweight Object	초기 DB File Size			DM_XX_TEST_REP_DB.DBF 180MB DM_XX_TEST_REP_IND.DBF 180MB
		5만	5만	Ｘ	DM_XX_TEST_REP_DB.DBF 330MB DM_XX_TEST_REP_DB.DBF 180MB
				Ｏ	DM_XX_TEST_REP_DB.DBF 180MB DM_XX_TEST_REP_IND.DBF 180MB
	DB Partitioning

2.     Test 시스템 H/W 및 S/W 구성

모델	용도	설치 S/W		비고
		구분	내역
Lenovo T61 (Laptop)	이미지 서버	O/S	Windows Server 2003 Standard Edition SP2
		CPU	Dual Core 2.5GHz
		Memory	4G (/pae 옵션 적용)
		DBMS	Oracle 10.2.0.3
		DCTM	Content Server 6.5 sp1 DA (Documentum Administrator) HVS(High Volume Server)

HVS - Batch Processing
Object Count = 10,000

1245211117265
1245211343187
225922 = 3분 8초


1245211836812
1245212179109
342297 = 5분 7초


Object Count = 50,000
1245292285562
1245293823328
1537766 = 25분 6초

1245374526359
1245375786609
1260250 = 21분

1245293993156
1245296233468
2240312 = 37분 3초


HVS - LightWeight Object Test
초기 DB Size
DM_XX_TEST_REP_DB.DBF 180MB (188,751,872 바이트)
DM_XX_TEST_REP_IND.DBF 180MB (188,751,872 바이트)

초기 HDD 여유 공간
52.2GB

lwso 적용전 DB Size
5만건 저장
DM_XX_TEST_REP_DB.DBF 330MB (346,038,272 바이트)
DM_XX_TEST_REP_DB.DBF 180MB (188,751,872 바이트)

HDD 공간
41.8GB

사용된 Object(LightWeight Object 적용 안됨)
CREATE TYPE "emc_payment_check" (
account integer,
check_number integer,
transaction_date date,
amount float,
bank_code integer,
routing integer
) WITH SUPERTYPE "dm_document" PUBLISH


-- lwso 적용 전 DB Size
5만건 저장
DM_XX_TEST_REP_DB.DBF 330MB (346,038,272 바이트)
DM_XX_TEST_REP_DB.DBF 180MB (188,751,872 바이트)

HDD 공간 = 41.8GB

-- lwso 적용 후 DB Size
CREATE SHAREABLE TYPE emc_payment_bank (
bank_code integer,
routing integer,
branch integer repeating
) WITH SUPERTYPE dm_sysobject PUBLISH


CREATE LIGHTWEIGHT TYPE emc_payment_check (
account integer,
check_Number integer,
transaction_date date,
amount float,
deductions float repeating
) SHARES emc_payment_bank PUBLISH


HDD 공간 = 41.9GB
1245377891171
1245379119671
1228500 = 20분 4초

DM_XX_TEST_REP_DB.DBF 180MB (188,751,872 바이트)
DM_XX_TEST_REP_IND.DBF 180MB (188,751,872 바이트)







java.exe -Xms256m -Xmx1024m -Xbootclasspath/a:C:\Documentum\config -classpath "D:\HVS_Test\HVS\bin;C:\Program Files\Documentum\Shared\dfc.jar;C:\Program Files\Documentum\Shared\log4j.jar;C:\Program Files\Documentum\dctm.jar" batch.StdBatchingExample

java.exe -Xms256m -Xmx1024m -Xbootclasspath/a:C:\Documentum\config -classpath "D:\HVS_Test\HVS\bin;C:\Program Files\Documentum\Shared\dfc.jar;C:\Program Files\Documentum\Shared\log4j.jar;C:\Program Files\Documentum\dctm.jar" lwso.lwsoExample

java.exe -Xms256m -Xmx1024m -Xbootclasspath/a:C:\Documentum\config -classpath "D:\HVS_Test\HVS\bin;C:\Program Files\Documentum\Shared\dfc.jar;C:\Program Files\Documentum\Shared\log4j.jar;C:\Program Files\Documentum\dctm.jar" batch.lw_batch xn_test_rep dmadmin dmadmin 1000 50000




C:\>java.exe -Xms256m -Xmx1024m -Xbootclasspath/a:C:\Documentum\config -classpat
h "D:\HVS_Test\HVS\bin;C:\Program Files\Documentum\Shared\dfc.jar;C:\Program Files\Documentum\Shared\log4j.jar;C:\Program Files\Documentum\dctm.jar" batch.lw_batch xn_test_rep dmadmin dmadmin 1000 50000
Started @ 2009. 6. 22 오전 10:35:29
Finished @ 2009. 6. 22 오전 10:51:44
Elapsed 975 sec


한글 파일 @!%&.tif
한글 파일명으로_테스트.tif

DFS에서 UCF 사용하기

1. JDK 1.6 or JRE 1.6 이상을 로컬 컴퓨터에 설치함
2. -Webapp-/da or webtop/WDK/System/ucfinit.jar 파일을 로컬에 복사
3. java -cp "c:\ucfinit.jar" com.documentum.ucf.client.install.TestInstall "http://localhost" "/wdk/contentXfer/ucf.installer.config.xml"
을 이용해 ucf client jar파일을 로컬에 설치 후 재부팅 시킨 후에 사용하면 됨!!

휴우~ 모든게 맨땅에 헤딩이구낭~!!!

Create Documentum ACL Script

create,c,dm_acl
set,c,l,owner_name
INSERT OWNER NAME HERE
set,c,l,object_name
INSERT ACL NAME HERE
set,c,l,description
INSERT ACL DESCRIPTION HERE
grant,c,l,dm_owner,7
revoke,c,l,dm_owner,execute_proc,change_location
grant,c,l,dm_world,1
revoke,c,l,dm_world,execute_proc,change_location
grant,c,l,,ExtendedPermit,,execute_proc
save,c,l

LDAPSync Mehtod 실행

다큐멘텀에서 LDAP Sync를 command 모드에서 실행시켜 관련 Error Log를 파악할때 유용
하지만 아직도 풀어야 할 숙제는 많이 남아 있다는거..흐흐~!

java com.documentum.ldap.LDAPSync -docbase_name rep_dev_ecm -user_name dmadmin -full_sync true -create_default_cabinet true -method_trace_level 10

사용자의 Default Cabinet을 생성시키는 Parameter Value
create_default_cabinet

Documentum Client Capability

Client(Webtop, Desktop, Customized Client based on DFC, DFS)에서 접근시 계정별 기본 접근 권한이 정의되어 있어서 사용자가 작업 할 수 있는 기능에 제한을 두는 것이 Client Capability이다.

Client Capability

1. Consumer : can search, view and copy documents and forward tasks in workflows. default capability.
2. Coordinator : Consumer + create cabinet, workflows, and virtual documents and view hidden objects.
3. Contributor : Coordinator + create documents and folders, modify regular documents and virtual documents(including checkin and checkout), and delete documents
4. System Administrator : Contributor + can manage Content Server, repository, and users and groups.

r_object_id의 구성

Documentum의 dm_sysobject의 하위 Object들의 Key값은 r_object_id로 구성된다.
r_object_id의 구성은 16자리인데
그 중 2자리는 Object Type, 6자리는 Repository ID, 8자리는 Unique ID값들로 구성된다는것을 알고 있다면 Documentum을 이해하는데 도움이 된다. 약간 MOSS와 비슷한 느낌도 있지만 어쨋든 독특한 시스템인 것 같은 생각이 든다.

ex)0900271280000beb
Type Repository ID Unique ID
09 002712 80000beb Hex값

Object Type들의 종류로는
00 dmi_audittrail_attrs
03 dm_type
05 dmr_containment
06 dmr_content
08 dm_application
08 dm_job
08 dm_procedure
08 dm_query
08 dm_script
08 dm_smart_list
09 dm_document
0b dm_folder
0c dm_cabinet
0d dm_assembly
10 dm_method
11 dm_user
12 dm_group
19 dm_registered
1f dmi_index
26 dmi_registry
27 dm_format
28 dm_filestore
28 dm_store
2c dm_distributedstore
2e dmi_type_info
2f dm_dump_record
30 dmi_dump_object_record
31 dm_load_record
32 dmi_load_object_record
37 dm_relation
3a dm_location
3b dm_fulltext_index
3c dm_docbase_config
3d dm_server_config
40 dm_blobstore
41 dm_note
45 dm_acl
46 dm_policy
49 dmi_package
4a dmi_workitem
4c dm_activity
4d dm_workflow
53 dm_literal_expr
5e dm_federation
5f dm_audittrail_acl
5f dm_audittrail_group
5f dm_audittrail
66 dm_alias_set
6a dmi_dd_attr_info
0b dm_taxonomy
0b dm_xml_application
6b dm_display_config
20 dmi_sequence

[DQL]Object Security 관련 Sample Query

SELECT r_accessor_name, r_accessor_permit
FROM dm_acl
WHERE object_name = (
SELECT acl_name
FROM dm_document
WHERE r_object_id = '0900271280000beb')
AND owner_name = (
SELECT acl_domain
FROM dm_document
WHERE r_object_id = '0900271280000beb')

SELECT acl_name, acl_domain
FROM dmi_type_info
WHERE r_type_name = 'dm_document'

SELECT acl_name, acl_domain
FROM dm_folder
WHERE object_name = 'Temp'

SELECT acl_name, acl_domain
FROM dm_user
WHERE user_name = 'dmadmin'

[DQL]Group 관련 Sample Query

SELECT group_name, group_address, owner_name, group_admin
FROM dm_group
WHERE group_name = 'docu'

SELECT group_name
FROM dm_group WHERE ANY i_all_users_names = 'dmadmin'

SELECT group_name
FROM dm_group
WHERE group_class = 'role'

[DQL]User관련 Query Samples

Documentum Query Language 중 User 생성과 관련된 Sample Query

#사용자별 문서 등록 현황
SELECT owner_name, count(*)
FROM dm_sysobject
WHERE r_object_id like '09%'
GROUP BY owner_name


# User 관 련 Sample Querys
SELECT user_name, user_login_name, user_address, description, home_docbase, user_state
FROM dm_user
WHERE user_login_name = 'gildong'

CREATE dm_user object
SET user_name = 'Gil-Dong',
SET user_login_name = 'gildong',
SET user_address = 'gildong@help.me',
SET user_group_name = 'docu',
SET user_source = 'inline password',
SET user_privileges = 2,
SET client_capability = 4

CREATE dm_folder object
SET object_name = 'gildong',
SET owner_name = 'Gil-Dong'

UPDATE dm_user objects
SET default_folder = 'Cabinet/gildong'
WHERE user_login_name = 'gildong'

#lists the inactive users in repository
SELECT user_name, user_login_name
FROM dm_user
WHERE user_state = 1 OR user_state = 3

SELECT user_name, user_privileges, user_xprivileges
FROM dm_user
WHERE user_login_name = 'gildong'

#LDAP 설정 정보 조회
SELECT object_name
FROM dm_ldap_config

[Book]A Beginner's Guide to Developing Documentum Desktop Applications

Hutt~

My keyboard got crzay mode. I bought this book for MoL Prject.

I moved on ECM industry 3 months ago.

I should handle documentum solution for our customer's requirements.

It seems like MOSS 2007(Microsoft Office Sharepoint portal Server). It provide Check-in, Check-out, Virtual Documents, etc.

However, our development language is very very old. It's VB 6. As I know, MS stopped the technical support on it.