New Features in Version 3.0 SP1
The following features were introduced in Vectorwise 3.0 Service Pack 1.
• IPV4 and IPV6 data types and functions--New data types IPV4 and IPV6 store IPv4 and IPv6 host addresses, respectively, in binary format. Coercion between both types and other data types, such as VARCHAR, is supported. The IPV4 and IPV6 types also support standard comparison operators, new conversion functions INET_PTON, INET_NTOP, INET6_PTON, INET6_NTOP, and bitwise functions BIT_AND, BIT_OR, BIT_XOR, BIT_NOT.
• Multiple indexes--Vector supports secondary indexes in addition to primary (clustered) indexes. For more information, see
Creating a Secondary Index and CREATE INDEX in the Vector
SQL Language Guide.
• New SQL functions.
Date and time functions:
– ADD_MONTHS
– ROUND(datetime)
– TRUNC(datetime)
– SYSDATE
Conversion functions:
– TO_CHAR(datetime)
– TO_DATE
– TO_TIME
– TO_TIMESTAMP
– TO_TIMESTAMP_TZ
IP network address functions:
– INET_PTON or IPV4
– INET_NTOP or IPV6
– INET6_PTON
– INET6_NTOP
– Bitwise functions that operate on IPV4 or IPV6 addresses
For details, see the Vector SQL Language Guide.
• vwinfo option to List PDT Usage--The vwinfo –M option lists, for each table, the number of inserts, deletes, modified fields, and the amount of memory used by PDTs. This information lets you identify tables that are good candidates for MODIFY...TO COMBINE operations, to free memory. For more information, see
View Information about a Database and
vwinfo PDT Usage Display.
• New extensions to the CALL VECTORWISE statement include: GETCONF, VWLOG_ROTATE, and VWLOG_RELOAD. For details, see the Vector SQL Language Guide.
• High Availability Option for Red Hat Cluster Suite--A service script, ha_vectorwiseXX, can be generated that can be used to monitor and control the Vector instance in the cluster. For more information, see Configuring the High Availability Option for Red Hat Cluster Suite in the Getting Started guide.
• ODBC Serverless Client Connections--The Ingres ODBC Administrator lets you configure ODBC to connect to a remote database without the use of a local Communications Server or Name Server. For more information, see the Ingres ODBC Administrator help.
• LZ4 compression is now turned off by default. For more information, see the description of the compression_lz4_enabled parameter.