It's all about the answers!

Ask a question

Importing requirements from Excel to DNG is very slow


Vishnu Kumar (2621627) | asked Apr 11 '18, 4:26 a.m.

Hello Team,
We are trying to import requirements from our inhouse legacy system to DNG. We had already exported the requirements in excel and we are using a script to import the requirements into DNG project areas using OSLC. The incoming projects areas are GC enabled. Total number of artifacts are 45000.

As for our infrastructure, we are currently at Rational CLM 6.0.5 ifix 002 and having following server configuration (VM) Application OS CPU RAM Disk
1 IHS (Reverse Proxy) Windows 2012 8 16 50 IBM HTTP
2 JTS/CCM/GC/LDX/RB Windows 2012 8 16 100 IBM CLM
3 DNG Windows 2012 8 32 200 IBM CLM
4 DM Windows 2012 8 16 200 IBM CLM
5 DB Server Windows 2012 8 16 150 Extendable for DNG SQL Server 2014 (Single Node)
6 DCC/LQE Windows 2012 16 32 100 IBM CLM
7 RELM Windows 2012 8 24 100 IBM CLM

When the script is running, we do not see any load (cpu, memory, disk) on the server however the script is very slow and importing 7-8 artifacts in a minute. Has anyone else encountered the same issue while importing requirements into GC enabled project areas in DNG ?

Regards
Vishnu Kumar

One answer



permanent link
Rosa Naranjo (2.9k11723) | answered Apr 11 '18, 1:31 p.m.
FORUM MODERATOR / JAZZ DEVELOPER

Vishnu
All I know is that it is listed as a resource intensive scenario on this wiki page: https://jazz.net/wiki/bin/view/Deployment/CLMExpensiveScenarios#Importing_a_large_number_of_requ

Any reason you are using OSLC vs the OOTB Import feature?
Are you using a SSD drive? SSDs are highly recommended for DNG.


Comments
Vishnu Kumar commented Apr 12 '18, 3:54 a.m.
Thanks Rosa for the response

OOTB ?, does it mean out of the box ? 

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.