Was this helpful?
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.
Disaster Recovery (Linux)--The movedb utility copies Vector data locations from one machine to another. It can be used to create a backup copy of the database for disaster recovery purposes. For more information, see movedb Command--Copy Data Locations to Another Machine and Copy Database to a Backup Location Using movedb (Linux).
New extensions to the CALL X100 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 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 ODBC Administrator help.
LZ4 compression is now turned off by default. For more information, see the description of the compression_lz4_enabled parameter.
Last modified date: 11/09/2022