It's all about the answers!

Ask a question

What is the size limitation for an attachment in RTC


Jagadish R Rao (10612111) | asked Sep 03 '09, 8:18 a.m.
I am curious to know 2 things

1) What is the limitation of a single attachment / multiple attachments that can be enabled with a single work item and Also is there any size limitation applicable also to source code management as well

2) How are attachments stored in Backend database . Is it stored as blob for db2 , but the max limit of blob data type is 2 GB and if that is the case how is it possible to store files greater than 2 GB , does it do a split and store ?

Thanks & Regards
Jagadish

4 answers



permanent link
Patrick Streule (4.9k21) | answered Sep 03 '09, 8:48 a.m.
JAZZ DEVELOPER
1) What is the limitation of a single attachment / multiple
attachments that can be enabled with a single work item and Also is
there any size limitation applicable also to source code management
as well

The default size limit for an attachment is 50MB. This value can be
configured in the Admin Web UI.
I don't know the details about SCM, but the limit is certainly higher.

2) How are attachments stored in Backend database . Is it stored as
blob for db2 , but the max limit of blob data type is 2 GB and if
that is the case how is it possible to store files greater than 2 GB
, does it do a split and store ?

Attachments are stored in the repository, and we don't provide a split
option for them. If you have many of these huge files, it might be a
better option to not store them as attachments in the repository but to
store them somewhere else. You can then add a 'Related Artifact' link to
the work item that points to the attachment location.

--
Regards,
Patrick
Jazz Work Item Team

permanent link
Jagadish R Rao (10612111) | answered Sep 04 '09, 1:01 a.m.
Hi Patrick,

Thanks a lot , I was able to configure it to a higher number and use, but is there normative guidelines on how to handle bigger files in team concert , should the team be using external tools like content managers / filenet or RTC is capable of handling files which are in the range of 80 ~ 150 MB (This are basically video files) or binaries

Thanks & Regards
Jagadish

1) What is the limitation of a single attachment / multiple
attachments that can be enabled with a single work item and Also is
there any size limitation applicable also to source code management
as well

The default size limit for an attachment is 50MB. This value can be
configured in the Admin Web UI.
I don't know the details about SCM, but the limit is certainly higher.

2) How are attachments stored in Backend database . Is it stored as
blob for db2 , but the max limit of blob data type is 2 GB and if
that is the case how is it possible to store files greater than 2 GB
, does it do a split and store ?

Attachments are stored in the repository, and we don't provide a split
option for them. If you have many of these huge files, it might be a
better option to not store them as attachments in the repository but to
store them somewhere else. You can then add a 'Related Artifact' link to
the work item that points to the attachment location.

--
Regards,
Patrick
Jazz Work Item Team

permanent link
Patrick Streule (4.9k21) | answered Sep 04 '09, 2:14 p.m.
JAZZ DEVELOPER
Thanks a lot , I was able to configure it to a higher number and use,
but is there normative guidelines on how to handle bigger files in
team concert , should the team be using external tools like content
managers / filenet or RTC is capable of handling files which are in
the range of 80 ~ 150 MB (This are basically video files) or
binaries

I am not aware of any normative guidelines, but files in the 100MB range
shouldn't be an issue. I was more concerned about the 1GB+ files that you
mentioned. To my knowledge, SCM has put considerable effort into managing
very large files, but work item attachments are more geared towards the
use case of attaching documents, screen shots, logs etc. to work items to
help it's owner investigate a bug.

If videos fall roughly into this category, I don't see any issue. Using
RTC Work Items as a media asset management system would not sound quite
right to me, though.

--
Regards,
Patrick
Jazz Work Item Team

permanent link
Stephane Leroy (1.4k149) | answered Sep 05 '13, 12:16 p.m.
JAZZ DEVELOPER
edited Sep 06 '13, 3:05 a.m.
Hi,

strange enough to revive this 4-years-old thread...
but this blog post: http://sleroyblog.wordpress.com/2013/09/05/recommendations-educated-guesses-for-clm-limitations/  provides currently known (*) CLM/JTS/RTC/RQM/RRC limitations plus some "educated guesses" on sizing aspects.

Regards,
St├ęphane

(*): at this date.

Your answer


Register or to post your answer.