Skip navigation

Jordan Chernev

NZ In, NZ Out
Login or Register to find out more about jchernev
Jordan Chernev has no profile image available
Name:
Jordan Chernev
Status Level:
Rookie Rookie (171 points)
Member Since:
Jun 24, 2011
Groups:
TwinFin Talk   Retail/CPG Focus   Enzee Universe

Recent Activity

Jordan Chernev replied to Groom is not releasing space

"Ah, I see what you are talking about. Don't the query history statistics get written to disk and then imported though?"

in TwinFin Talk 10 replies
17 hours ago
Jordan Chernev replied to Groom is not releasing space

"Actually, I poked around for a bit and it seems like you can:   select * from histdb.."$hist_plan_prolog_1" p inner join histdb.."$hist_que"

in TwinFin Talk 10 replies
1 day ago
Jordan Chernev replied to Groom is not releasing space

"Just checked the query history db in our environment and none of the views/tables contains an actual reference to a txid. There's a guid-lik"

in TwinFin Talk 10 replies
1 day ago
Jordan Chernev replied to Groom is not releasing space

"@ Shawn - is there an indicator of when a certain transaction got executed? I'm looking for something that will tell me when a tx was ran so"

in TwinFin Talk 10 replies
1 day ago
Jordan Chernev replied to Query Plan Questions

"This just looks like your query filtering criteria... can you post the full execution/explain plan please?"

in Enzee Universe 2 replies
1 day ago
Jordan Chernev replied to Looping in SQL

"You'd have to do it "manually" in a relational server environment. Depending on your hierarchy needs it could be anywhere between 100 record"

in TwinFin Talk 12 replies
1 day ago
Jordan Chernev replied to ODBC

"@ Shawn - I ran lspci -vv on the host and all of the interfaces came back with a Gigabit. I assume it's dual Gigabit as we have link bonds a"

in Enzee Universe 8 replies
1 day ago
Jordan Chernev replied to ERROR [HY000] ERROR:  64004 : Column size limit exceeded

"Could it be that you have new data records that are causing your process to break?"

in TwinFin Talk 3 replies
1 day ago
Jordan Chernev replied to factrel planner not working

"I've helped the planner get a better execution plan by adding a mview on the fact table. That being said, the process recommendation is prob"

in Users 9 replies
1 day ago
Jordan Chernev replied to Start learning Netezza

"venky, I think you may need a customer login to either the website or to Netezza's FTP for the actual pdfs. If you're lucky, they may be ava"

in Users 7 replies
1 day ago
Jordan Chernev replied to CPU/IO usage in Twinfin 12

"Probably at the switch level for those ports that are connected to the rest of your servers/network.   I'm not sure about the internal fabr"

in Users 7 replies
2 days ago
Jordan Chernev replied to ODBC

"I'm playing with a Twin-Fin 3 (1000-3) and I can write out to an external table pointing to /dev/null on the host at a max of 180 MB/sec.  "

in Enzee Universe 8 replies
1 week ago
Jordan Chernev replied to Concatenating multiples values in rows to a single column value in Netezza SQL

"Is that to be expected?"

in TwinFin Talk 13 replies
1 week ago
Jordan Chernev replied to Start learning Netezza

"Hey venky,   I'd start with the Netezza documentation. I've found that it's better to start with the "System Administrators Guide" first as"

in Users 7 replies
1 week ago
Jordan Chernev replied to CPU/IO usage in Twinfin 12

"The query execution plans provide this information to an extent. I'm not sure if you can monitor that overall. Maybe Shawn would know more.."

in Users 7 replies
1 week ago
Jordan Chernev replied to Swap partition event alert setup

"I don't know how to do this but out of curiosity here... are you trying to monitor for large queries that are writing to the temp space or?"

in Users 4 replies
1 week ago
Jordan Chernev replied to error: Got exception: unexpected transaction command in exec_stmt_execsql()

"One thing that you could do is tail the log via   tail -f /nz/kit/log/postgres/pg.log while the sproc is running so you can see exactly whe"

in TwinFin Talk 6 replies
1 week ago
Jordan Chernev replied to Encoding?

"Thanks Shawn!"

in TwinFin Talk 2 replies
1 week ago
Jordan Chernev replied to Looping in SQL

"Nick, I was referring to the bridge table that needs to be built out "manually" by exploding the tree.   If you're in a mixed database envi"

in TwinFin Talk 12 replies
1 week ago
Jordan Chernev replied to error: Got exception: unexpected transaction command in exec_stmt_execsql()

"Do you have an actual SQL statement we can look at?"

in TwinFin Talk 6 replies
1 week ago
Jordan Chernev replied to Concatenating multiples values in rows to a single column value in Netezza SQL

"Does the following work?     ------------------------------------------------------------------------------ -- c) 2010 Netezza Corporation."

in TwinFin Talk 13 replies
1 week ago
Jordan Chernev started the discussion Encoding?

"Is there a way to check the encoding of Netezza or does it default to Latin-1?"

in TwinFin Talk 0 bookmarks
1 week ago

Friends

    Jordan Chernev hasn't added any friends yet.

Jordan Chernev's Most Liked Content