RDBMS Comparisons
Not a problem report but a request for help: the poster circulated a wide feature/limits comparison chart of RDBMSes (Sybase, Oracle, Informix, DB2, Interbase, Ingres, PostgreSQL, Teradata, etc.), mainly aimed at Intel/Linux and BSD platforms, and asked readers to fill in the blanks. Replies complained about line wrapping (he reposted a semicolon-delimited version and declined to post a binary attachment), suggested adding InterSystems Caché, and supplied data: Art Kagel gave detailed limits for Informix IDS 7.3, IDS.2000/9.20, XPS 8.x and SE 7.30, and another poster supplied DB2 6.1 figures and pricing. No single conclusion or "best" product was reached.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello, in choosing a DBMS, I've built a little chart. Any help in filling in the blanks would be much appreciated. NOTE: This chart is quite wide, and may wrap viciously on some of your newsreaders. DBMS Comparison Chart DBMS Sybase Oracle Informix DB2 Interbase Ingres II PostgreSQL Teradata NonStop SQL/MX University Postgres University Ingres Sybase INC Orace INC Informix IBM Inprise / Borland CA PostGreSQL NCR COMPAQ / Tandem UBerkeley UBerkeley linux.sybase.com platforms.oracle.com/linux www.informix.com/informix/products/linux/ www.software.ibm.com/data/db2/linux/ www.interbase.com www.cai.com/bpp/ www.postgresql.org www3.ncr.com/product/teradata/ihttp://s2k-ftp.CS.Berkeley.EDU/ingres/xpd.htm http://epoch.cs.berkeley.edu:8000/postgres/postgres.html ASE 11.0.3.3 ASE 11.9.2 8i (Enterprise Edition) IDS 7.3.x IDS2000 4.0 5.1.1 BETA OS Linux Linux Linux L2.0.36/gc2.0.7/(RH5.2) L2.2.5/gc2.1.1 L2.0.35/gc2.0.7+/pdksh/libstdc++2.8.0+/rpm RH4.2 RH5.1 c5/6,L2.0.27+ (RH5.1) Linux SVR4/NT NonStop Kernel OS rel G40+) MaxDevSize 2GB 2GB 2GB 2GB MaxNumDev 256 256 MaxNumDB 32767 21,000,000 MaxDBsize 8TB 32TB 1TB+ MaxDevPerDB 128 128 MaxIdxPerDB 2^32 MaxTablePerDB MaxRowPerDB MaxTableSize 64TB 32TB MaxNumTables 477,000,000 2^16 MaxIdxPerTable 77 2^16 MaxColPerTable 2767 MaxRowPerTable 2^32 MaxColPerIdx 16 MaxRowSize 32kB 64kB MaxLogSize 2GB 4GB MaxLogsPerDB 128 MinDiskSpace 64MB 200MB 120MB 10MB 10MB MinRAM 32MB 64MB 100MB 16MB 16MB QueryLang SQL SQL SQL SQL, PostQUEL SQL SQL SQL SQL SQL, QUEL SQL, PostQUEL SQL SQL PostQUEL QUEL TransactSQL PL/SQL isql Replication Replication Server (nonLinux) Advanced Replication yes yes no (self program) Ingres Replicator Mirroring built in mirroring Mirror Shadow(incl) Distribution Replication Server/OmniConnect(nLnx) yes, with recovery and partial commit federated / distributed with recovery (incl) Ingres Vision FailOver OpenSwitch/Replication Server(nLnx) Security C2 XA support XA Server (11.9.2) <non Linux> Informix CLI yes yes TPM yes JDBC yes www.blackdown.org/java-linux.html yes yes ODBC ftp://ftp1.informix.com/dist/IDN/linux/odbc/ yes Win only
Hi Can you send me the soft copy. Thanks Muhammad Usman musman@iffco.com Sent via Deja.com http://www.deja.com/ Before you buy.
Loki wrote in message <3Jpj4.70$FS.22310@carnaval.risq.qc.ca>... > >Hello, in choosing a DBMS, I've built a little chart. Any help in filling in >the blanks would be much appreciated. > >NOTE: This chart is quite wide, and may wrap viciously on some of your >newsreaders. Yes it does! On a more serious note, you have missed off Cache from Intersystems. I think that you will find it's numbers quite interesting (you may need a few more columns for O/S and H/w platforms though). look at www.edbms.com
In comp.databases Chris Casey <Chris.Casey@hendersonnospam.com> wrote: > Loki wrote in message <3Jpj4.70$FS.22310@carnaval.risq.qc.ca>... >> >>Hello, in choosing a DBMS, I've built a little chart. Any help in filling > in >>the blanks would be much appreciated. >> >>NOTE: This chart is quite wide, and may wrap viciously on some of your >>newsreaders. > Yes it does! :-) > On a more serious note, you have missed off Cache from Intersystems. > I think that you will find it's numbers quite interesting (you may need a > few more columns for O/S and H/w platforms though). look at www.edbms.com I was more or less hoping for something that would run on an Intel/Linux or Intel/Free-Net-Open-BSD based system. SPARC/Solaris and Alpha/Unix would be considered but not as favourably. (which is why almost everything listed is Linux)
Maybe post a attachment is better. Loki wrote: > Hello, in choosing a DBMS, I've built a little chart. Any help in filling in > the blanks would be much appreciated. > > NOTE: This chart is quite wide, and may wrap viciously on some of your > newsreaders. > > DBMS Comparison Chart > > DBMS Sybase Oracle Informix DB2 Interbase Ingres II PostgreSQL Teradata NonStop SQL/MX University Postgres University Ingres > Sybase INC Orace INC Informix IBM Inprise / Borland CA PostGreSQL NCR COMPAQ / Tandem UBerkeley UBerkeley > linux.sybase.com platforms.oracle.com/linux www.informix.com/informix/products/linux/ www.software.ibm.com/data/db2/linux/ www.interbase.com www.cai.com/bpp/ www.postgresql.org www3.ncr.com/product/teradata/ihttp://s2k-ftp.CS.Berkeley.EDU/ingres/xpd.htm http://epoch.cs.berkeley.edu:8000/postgres/postgres.html > ASE 11.0.3.3 ASE 11.9.2 8i (Enterprise Edition) IDS 7.3.x IDS2000 4.0 5.1.1 BETA > OS Linux Linux Linux L2.0.36/gc2.0.7/(RH5.2) L2.2.5/gc2.1.1 L2.0.35/gc2.0.7+/pdksh/libstdc++2.8.0+/rpm RH4.2 RH5.1 c5/6,L2.0.27+ (RH5.1) Linux SVR4/NT NonStop Kernel OS rel G40+) > MaxDevSize 2GB 2GB 2GB 2GB > MaxNumDev 256 256 > MaxNumDB 32767 21,000,000 > MaxDBsize 8TB 32TB 1TB+ > MaxDevPerDB 128 128 > MaxIdxPerDB 2^32 > MaxTablePerDB > MaxRowPerDB > MaxTableSize 64TB 32TB > MaxNumTables 477,000,000 2^16 > MaxIdxPerTable 77 2^16 > MaxColPerTable 2767 > MaxRowPerTable 2^32 > MaxColPerIdx 16 > MaxRowSize 32kB 64kB > MaxLogSize 2GB 4GB > MaxLogsPerDB 128 > MinDiskSpace 64MB 200MB 120MB 10MB 10MB > MinRAM 32MB 64MB 100MB 16MB 16MB > QueryLang SQL SQL SQL SQL, PostQUEL SQL SQL SQL SQL SQL, QUEL SQL, PostQUEL SQL SQL PostQUEL QUEL > TransactSQL PL/SQL isql > > Replication Replication Server (nonLinux) Advanced Replication yes yes no (self program) Ingres Replicator > Mirroring built in mirroring Mirror Shadow(incl) > Distribution Replication Server/OmniConnect(nLnx) yes, with recovery and partial commit federated / distributed with recovery (incl) Ingres Vision > FailOver OpenSwitch/Replication Server(nLnx) > Security C2 > XA support XA Server (11.9.2) <non Linux> Informix CLI yes yes > TPM yes > JDBC yes www.blackdown.org/java-linux.html yes yes > ODBC
Loki wrote: > Hello, in choosing a DBMS, I've built a little chart. Any help in filling in > the blanks would be much appreciated. > > NOTE: This chart is quite wide, and may wrap viciously on some of your > newsreaders. > > DBMS Comparison Chart Here are entries for the Informix DBMS products. There are 4 distinct servers available. > > > DBMS Informix > Company Informix > WEB Site www.informix.com/informix/products/linux/ > Version(s) IDS 7.3x IDS.2000 (9.20) IDS/XPS 8.xx SE 7.30 Description Base Enterprise IDS w/ Object DSS/DW Engine with Simple Zero RDBMS Extensions Shared Nothing Cluster Maintenance RDBMS Co-Server Technology CISAM based > OS(es) Linux/NT/Unix* Linux/NT/Unix* NT/Unix* ^ Linux/NT/Unix* * - Most UNIX versions/platforms supported ^-Linux not yet supported by this product (rumors indicate a port is possible is demand is there) > > MaxDevSize 2GB 2GB 2GB 2GB(COOKED files) > MaxNumDev 1024 1024 Unlimited (1024/co-server) (limited 1/table) > MaxNumDB 21,000,000 21,000,000 21,000,000 1/server > MaxDBsize 2TB 2TB Unlimited (2TB/co-server) No logical limit > MaxDevPerDB 1024 1024 Unlimited (1024/co-server) No logical limit > MaxIdxPerDB ~7.6million ~7.6million Unlimited (~7.6M/co-server) No logical limit > MaxTablePerDB 477,102,080 477,102,080 Unlimited (477,102,080/co-server) 2^31-1 > MaxRowPerDB (depends on rowsize) (depends on rowsize) (depends on rowsize) (depends on rowsize) > MaxTableSize 2TB 2TB Unlimited (2TB/co-server) 2GB > MaxNumTables 477,102,080 477,102,080 Unlimited (477,102,080/co-server) No logical limit > MaxIdxPerTable 77 (154 on 4K page) 77 (154 on 4K page) 77 (154 on 4K page) No logical limit > MaxColPerTable 32767 32767 32767 32767 > MaxRowPerTable 4,277,659,295/table fragment (no imposed limit per table) 2^31-1 > MaxColPerIdx 16 16 16 8 > MaxRowSize 32KB 32KB 32KB 32,511 > MaxLogSize 2GB 2GB 2GB 2GB > MaxLogsPerDB > MinDiskSpace ~50MB ~50MB ~50MB ~2MB > MinRAM 64MB 64MB 64MB 1MB + ~500KB/user > QueryLang SQL SQL(w/ORDBMS ext) SQL SQL > MaxInstances/host 255 255 255 No logical limit MaxCoservers NA NA No logical limit NA > > Replication yes (two types) yes (two types) not available not available > > Mirroring yes yes yes no (OS mirror supported) > Distribution ----------- Full distributed queries and updates with full two-phase commit and heuristic recovery ------------- > FailOver reconnect to replicant reconnect to replicant Failover server on cluster partner reconnect to duplicate server > Security C2 C2 C2 ?? > XA support Informix CLI Informix CLI Informix CLI Informix CLI > TPM Supports most TPMs > JDBC yes yes yes yes > ODBC ftp://ftp1.informix.com/dist/IDN/linux/odbc/ > PERL DBI ------------- yes (DBD/DBI open source developed, now Informix supported and still open source) ------------------ > C-API ----------------------------- Informix CLI & ESQL/C ---------------------------------------------------------------- > Perl --------------------------------------------- InfPerl ------------------------------------------------------------------- > Java/JVM ?? > R-while-W yes yes yes yes > Pricing: ---------------------------------------------- Depends on OS and platform size. --------------------------------------- > GUI ---------------------------------------------- D4GL -------------------------------------------------------------------- > CLI ------------------------------------------- Informix CLI ---------------------------------------------------------------- Art S. Kagel
In comp.databases Loki <base@alpha.freya.vinland.rad.mgh.mcgill.ca> wrote: Hello, in choosing a DBMS, I've built a little chart. Any help in filling in the blanks would be much appreciated. NOTE: This chart is quite wide, and may wrap viciously on some of your newsreaders. (The chart is delimited with semicolons) DBMS Comparison Chart ; ; ; ; ; ; ; ; ; ; ; ; ; ; DBMS ;Sybase ;Sybase ;Oracle ; Informix ;Informix ; DB2 ; Interbase;www.interbase.com ;Ingres II ;PostgreSQL ;Teradata ;NonStop SQL/MX ; University Postgres ; University Ingres ; company ;Sybase INC ;Sybase INC ;Orace INC ; Informix ;Informix ; IBM ; Inprise ;Borland ;CA ;PostGreSQL ;NCR ;COMPAQ / Tandem ; UBerkeley ; UBerkeley ; www ;linux.sybase.com;linux.sybase.com ;platforms.oracle.com/linux ;www.informix.com/informix/products/linux/ ;; www.software.ibm.com/data/db2/linux/ ;www.borland.com;www.inprise.com ;www.cai.com/bpp/ ;www.postgresql.org ;www3.ncr.com/product/teradata/index.html ;www.tandem.com/prod_des/nsqlmxpd/nsqlmxpd.htm ;http://epoch.cs.berkeley.edu:8000/postgres/postgres.html ;http://s2k-ftp.CS.Berkeley.EDU/ingres/ ; version ;ASE 11.0.3.3 ;ASE 11.9.2 ;8i (Enterprise Edition) ; IDS 7.3.x ; IDS2000 ; ; 4.0 ; 5.1.1 ;BETA ; ; ; ; ; ; OS ;Linux ;Linux ;Linux ;L2.0.36/gc2.0.7/(RH5.2); L2.2.5/gc2.1.1 ;L2.0.35/gc2.0.7+/pdksh/libstdc++2.8.0+/rpm ; RH4.2 ; RH5.1 ;c5/6,L2.0.27+ (RH5.1) ;Linux ;SVR4/NT ;NonStop Kernel OS rel G40+) ; ; ; MaxDevSize ;2GB ;2GB ; ; ; ; ; 2GB ; 2GB ; ; ; ; ; ; ; MaxNumDev ;256 ;256 ; ; ; ; ; ; ; ; ; ; ; ; ; MaxNumDB ; ;32767 ; ; 21,000,000 ;21,000,000 ; ; ; ; ; ; ; ; ; ; MaxDBsize ; ;8TB ; ; ; ; ; ; 32TB ; ; ;1TB+ ; ; ; ; MaxDevPerDB ;128 ;128 ; ; ; ; ; ; ; ; ; ; ; ; ; MaxIdxPerDB ; ; ; ; ; ; ; ; 2^32 ; ; ; ; ; ; ; MaxTablePerDB ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; MaxRowPerDB ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; MaxTableSize ; ; ; ; 64TB ; 64TB ; ; ; 32TB ; ; ; ; ; ;
In comp.databases Carfield Yim <c8133594@comp.polyu.edu.hk> wrote: > Maybe post a attachment is better. It would, but that would violate binary posting in a non-binary group.
Hi all- I copied the original posting and pasted onto notepad. It read perfectly, no problem. Good job. Deb musman@my-deja.com wrote in article <86luec$j29$1@nnrp1.deja.com>... > Hi > > Can you send me the soft copy. > > Thanks > > > Muhammad Usman > musman@iffco.com > > > Sent via Deja.com http://www.deja.com/ > Before you buy. >
DBMS ; DB2 ; company ; IBM ; www ; www.software.ibm.com/data/db2/linux/ ; version ; 6.1 ; OS ;L2.0.35/gc2.0.7+/pdksh/libstdc++2.8.0+/rpm ; MaxDevSize ; 64-bti file addressing ; MaxNumDev ; ; MaxNumDB ; 256 ; MaxDBsize ; 4096*65,535*0.5 TB ; MaxDevPerDB ; ; MaxIdxPerDB ; 4096*65,535*0.5 TB ; MaxTablePerDB ; 4096*65,535 ; MaxRowPerDB ; ; MaxTableSize ; 512 GB ; MaxNumTables ; ; MaxIdxPerTable ; 32767 ; MaxColPerTable ; 1012 ; MaxRowPerTable ; ; MaxColPerIdx ; 16 ; MaxRowSize ; 32K (excluding long fields) ; MaxLogSize ; 4GB ; MaxLogsPerDB ; 128 ; MinDiskSpace ; 120MB ; MinRAM ; 100MB ; QueryLang ; SQL ; Replication ; yes ; Mirroring ; ; Distribution ; federated / distributed ; Security ; system ; XA support ; yes ; TPM ; yes ; JDBC ; www.blackdown.org/java-linux.html ; ; or www.alphaworks.ibm.com ; ODBC ; yes ; PERL DBI ; DBD-DB2-0.71.tar.gz ; C-API ; yes ; C++-API ; yes ; Perl ; yes ; Java/JVM ; (SQLJ) www.blackdown.org/java-linux.html; ; or www.alphaworks.ibm.com ; DateRange ; ; R-while-W ; yes ; ; ; ; ; Pricing: ; ; ; UnivDev $925 one time charge ; ; PersonalDev free download ; ; $39 one time charge ; ; WrkGrp $925 one time charge ; ; Enterprise $12,500 per CPU ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; GUI ; yes ; CLI ; yes (ODBC 3.5) ; Loki wrote: > Hello, in choosing a DBMS, I've built a little chart. Any help in filling in > the blanks would be much appreciated. > > NOTE: This chart is quite wide, and may wrap viciously on some of your > newsreaders. > > DBMS Comparison Chart > > etc.
In comp.databases Loki <base@alpha.freya.vinland.rad.mgh.mcgill.ca> wrote: Hello, in choosing a DBMS, I've built a little chart. Any help in filling in the blanks would be much appreciated. NOTE: This chart is quite wide, and may wrap viciously on some of your newsreaders. (The chart is delimited with semicolons) Thanks for the information on DB2 and Informix, it is now added Java/JVM - means it supports JAVA in SQL (ie SQLJ) Perl - means a Perl API, not DBI/DBD DBMS Comparison Chart ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; DBMS ;Sybase ;Sybase ;Oracle ; Informix ;Informix ;Informix ; DB2 ;Interbase ;www.interbase.com ;Progress ;Progress ;Ingres II ;PostgreSQL ;Teradata ;NonStop SQL/MX ; University Postgres ; Univers ity Ingres ;mSQL (MiniSQL) ; MySQL ; company ;Sybase INC ;Sybase INC ;Orace INC ; Informix Software Inc. ;;; IBM ; Inprise ;Borland ;Progress Systems Corp ;;CA ;PostGreSQL ;NCR ;COMPAQ / Tandem ; UBerkeley ; UBerkeley ;Hughes Software ; ; www ;linux.sybase.com;linux.sybase.com ;platforms.oracle.com/linux ;www.informix.com/informix/products/linux/ ;;; www.software.ibm.com/data/db2/linux/ ;www.borland.com;www.inprise.com ;www.progress.com ;;www.cai.com/bpp/ ;www.postgresql.org ;www3.ncr.com/product/teradata/index.html ;www.tandem.com/prod_des/nsqlmxpd/nsqlmxpd.htm ;http://epoch.cs.berkeley.edu:8000/postgres/postgres.html ;http://s2k-ftp .CS.Berkeley.EDU/ingres/ ;www.Hughes.com.au ; ; version ;ASE 11.0.3.3 ;ASE 11.9.2 ;8i (Enterprise Edition) ; IDS 7.3.x ; IDS2000 ; SE 7.30 ; 6.1 ; 4.0 ; 5.1.1 ;9 ;8.3b ;BETA ; ; ; ; ; ; ; ; OS ;Linux ;Linux ;Linux ;L2.0.36/gc2.0.7/(RH5.2); L2.2.5/gc2.1.1 ;L2.0.34/gc2.0.7;L2.0.35/gc2.0.7+/pdksh/libstdc++2.8.0+/rpm ; RH4.2 ; RH5.1 ; ;RH6.0 ;c5/6,L2.0.27+ (RH5.1) ;Linux ;SVR4/NT ;NonStop Kernel OS rel G40+) ; ; ; ; ; MaxDevSize ;2GB ;2GB ; ; 2GB ; 2GB ;2GB (fs only) ; 64-bit file addressing ; 2GB ; 2GB ; ; ; ; ; ; ; ; ; ; ; MaxNumDev ;256 ;256 ; ; 1024 ; 1024 ;1 per table ; ; ; ; ; ; ; ; ; ; ; ; ; ; MaxNumDB ; ;32767 ; ; 21,000,000 ; 21,000,000 ;1 per server ; 256 ; ; ; ; ; ; ; ; ; ; ; ; ; MaxDBsize ; ;8TB ; ; 2TB ; 2TB ; 2GB ; 128EB ; ; 32TB ;15PB ; ; ; ;1TB+ ; ; ; ; ; ; MaxDevPerDB ;128 ;128 ; ; ~7.6million ; ~7.6million ;no logical limt; ; ; ; ; ; ; ; ; ; ; ; ; ; MaxIdxPerDB ; ; ; ; 477,102,080 ; 477,102,080 ;no logical limt; ; ; 2^32 ;32,000 ; ; ; ; ; ; ; ; ; ; MaxTablePerDB ; ; ; ; ; ; ; 268,431,360 ; ; ; ; ;
Hello, in choosing a DBMS, I've built a little chart. Any help in filling in the blanks would be much appreciated. NOTE: This chart is quite wide, and may wrap viciously on some of your newsreaders. Thanks for the DB2 and Informix information. DBMS Comparison Chart DBMS Sybase Oracle Informix DB2 Interbase Progress Ingres II PostgreSQL Teradata NonStop SQL/MX University Postgres University Ingr es mSQL (MiniSQL) MySQL Sybase INC Orace INC Informix IBM Inprise / Borland Progress Systems Corp CA PostGreSQL NCR COMPAQ / Tandem UBerkeley UBerkel ey Hughes Software linux.sybase.com platforms.oracle.com/linux www.informix.com/informix/products/linux/ www.software.ibm.com/data/db2/linux/ www.interbase.com www.progress.com www.cai.com/bpp/ www.postgresql.org www3.ncr.com/product/teradata/index.html www.tandem.com/prod_des/nsqlmxpd/nsqlmxpd.htm http://epoch.cs.berkeley.edu:8000/postgres/postgres.html http://s2k-ftp.CS.Berke ley.EDU/ingres/ www.Hughes.com.au ASE 11.0.3.3 ASE 11.9.2 8i (Enterprise Edition) IDS 7.3.x IDS2000 SE 7.30 6.1 4.0 5.1.1 9 8.3b BETA OS Linux Linux Linux L2.0.36/gc2.0.7/(RH5.2) L2.2.5/gc2.1.1 L2.0.34/gc2.0.7 L2.0.35/gc2.0.7+/pdksh/libstdc++2.8.0+/rpm RH4.2 RH5.1 RH6.0 c5/6,L2.0.27+ (RH5.1) Linux SVR4/NT NonStop Kernel OS rel G40+) MaxDevSize 2GB 2GB 2GB 2GB (fs only) 64-bit file addressing 2GB 2GB MaxNumDev 256 256 1024 1/table MaxNumDB 32767 21,000,000 1/server 256 MaxDBsize 8TB 2TB 2GB 4096*65,535*0.5TB = 128EB 32TB 15PB 1TB+ MaxDevPerDB 128 128 7,600,000 unlimited MaxIdxPerDB 477,102,080 unlimited 2^32 32,000 MaxTablePerDB 4096*65,535 =268,431,360 =256x10^20 MaxRowPerDB MaxTableSize 2TB 2GB 512 GB 32TB MaxNumTables 477,102,080 unlimited 2^16 MaxIdxPerTable 77 (154 on 4k pages) unlimited 32767 2^16 MaxColPerTable 32767 32767 1012 32,000 MaxRowPerTable 4,277,659,295/tbl frgmnt (no lim/tbl) 2^31-1 2^32 2,147,483,647 MaxColPerIdx 16 8 16 MaxRowSize 32kB 32,511 32k 64kB 32000B MaxLogSize 2GB 2GB 2GB 4GB MaxLogsPerDB 128 MinDiskSpace 64MB 200MB 10MB 120MB 10MB 10MB MinRAM 32MB 64MB 16MB 100MB 16MB 16MB QueryLang SQL SQL SQL SQL, PostQUEL SQL(w/ORDBMS) SQL SQL SQL SQL SQL SQL, QUEL SQL, PostQUEL SQL SQL PostQUEL QUEL SQL SQL TransactSQL PL/SQL isql Replication Replication Server (nonLinux) Advanced Replication yes (two types) no yes no (self program) Ingres Replicator Mirroring built in mirroring Mirror yes no (OS only) Shadow(incl) Distribut