http://www.enzeecommunity.com/index.jspa All Content in The Netezza Community en Thu, 09 Sep 2010 08:09:14 GMT Clearspace 2.5.3 (http://jivesoftware.com/products/clearspace/) 2010-09-09T08:09:14Z en http://www.enzeecommunity.com/message/4929 Even if the data is already loaded, it should be very quick and simple to restructure the data as suggested by Shawn above on the Netezza system.. give it a try!   D. Thu, 09 Sep 2010 08:09:14 GMT dave.shuttleworth@edge-a.co.uk http://www.enzeecommunity.com/message/4929 2010-09-09T08:09:14Z 10 hours, 49 minutes ago 3 http://www.enzeecommunity.com/message/4928 Hi Everyone,        In one of our Netezza servers we got this error while we tried to start the netezza server with the nzstart command. When we tried pinging this machine we are getting repllies as it is onlie. Can some one help us to understand Thu, 09 Sep 2010 07:04:57 GMT ksampath@firstam.com http://www.enzeecommunity.com/message/4928 2010-09-09T07:04:57Z 11 hours, 53 minutes ago http://www.enzeecommunity.com/message/4925 It has to be 15MB per dataslice (at least).  Use "select count(*) from _v_dslice" to determine the number of dataslices on your system.   Also you wouldn't see any performance gain unless your source table is physically ordered on the column you Wed, 08 Sep 2010 23:19:11 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/message/4925 2010-09-08T23:19:11Z 19 hours, 39 minutes ago 3 http://www.enzeecommunity.com/message/4907 I think you might want to try the \o [file] command. That will redirect query output to a file. Wed, 08 Sep 2010 13:49:08 GMT joey.foley@va.gov http://www.enzeecommunity.com/message/4907 2010-09-08T13:49:08Z 1 day, 5 hours ago 2 http://www.enzeecommunity.com/message/4906 In Netezza DECIMAL is the same as NUMERIC - they can be used interchangeably and require the same amount of storage etc.   D. Wed, 08 Sep 2010 10:55:03 GMT dave.shuttleworth@edge-a.co.uk http://www.enzeecommunity.com/message/4906 2010-09-08T10:55:03Z 1 day, 8 hours ago 1 http://www.enzeecommunity.com/blogs/grill/2010/09/07/exadatas-soa-secondhand-on-arrival I've recently been involved in a rousing exchange out on Linked-In with one of Oracle's employees - on the Exadata machine and how it compares to Netezza. The conversation simply had to stop when the Oracle employee implied that I might be biased. exadata rdbms rac performance oracle secondhand Tue, 07 Sep 2010 19:44:06 GMT dbirmingham@virtualmach.com http://www.enzeecommunity.com/blogs/grill/2010/09/07/exadatas-soa-secondhand-on-arrival 2010-09-07T19:44:06Z 1 day, 23 hours ago http://www.enzeecommunity.com/message/4901 there are otions to show skew in the nzadmin tool - see System Administrattors guide. (search for 'skew')   Also there's a support script (nz_skew) that show the same info.   D. Mon, 06 Sep 2010 14:26:43 GMT dave.shuttleworth@edge-a.co.uk http://www.enzeecommunity.com/message/4901 2010-09-06T14:26:43Z 3 days, 4 hours ago 1 http://www.enzeecommunity.com/message/4899 Has anyone seen or know how to resolve this error: "Not enough memory to partition hash join".  The query that is producing this error runs everyday and has been fine.  While the tables have grown the dataset that is being worked on is pretty constant Sun, 05 Sep 2010 19:07:31 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/message/4899 2010-09-05T19:07:31Z 3 days, 23 hours ago http://www.enzeecommunity.com/message/4898 I am currently running nzrestore on a 2TB database.  The backup itself is on a snap drive and the new machine where the db is being created is a TwinFin P12.  The utility is being run with -v (verbose) option. Four tables in this db have 2billion+ rec Sun, 05 Sep 2010 14:10:35 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/message/4898 2010-09-05T14:10:35Z 4 days, 4 hours ago http://www.enzeecommunity.com/message/4897 There is no function named "date_trunc" that takes a single argument.  The date_trunc function takes two arguments:   select date_trunc('day', current_timestamp)   If you want to create a custom function that does the same thing as the Oracle Fri, 03 Sep 2010 15:55:49 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/message/4897 2010-09-03T15:55:49Z 6 days, 2 hours ago 4