I don't remember seeing a DDS defined file using VARLEN for character.
I have seen a bunch of DDL defined where all character fields are defined
as varying, no matter the minimum length. Mainly on MS-Sql and Oracle.
Maybe that helps account for what you see.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Monday, June 10, 2013 6:31 AM
To: midrange-l@xxxxxxxxxxxx
Subject: LTO4 storage
I am noticing that DB2 or 'traditional' stuff really compresses when saving to tape but stream file stuff doesn't.
I have one system that is primarily 'traditional' stuff and PRTERRLOG
TYPE(*VOLSTAT) VOLTYPE(3590) after a full system save says it fit
3,087,925 on one LTO4 tape and that got everything.
I have another system that's primarily stream file stuff and it only fit
1,024,936 on one tape and 689,570 on the second.
Full system saves, identical control groups. Saved with BRMS.
Perhaps stream file are generally more compressed while DB2 stuff keeps all that non variable length data all filled with blanks and stuff.
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
