DSXchange

Don't know if this related or not...

I just got a patch for memory leaks for datetime, numeric/decimal datatypes. We encountered the memory leaks when working with the Sybase, Teradata, and ODBC stages in PX. This patch was for DS751A on AIX. Ecase 76017.

My .dsadm environment file sources dsenv.

Thanks.

With your help Ray I ended up with the following code to get the projects. #!/bin/ksh ## SOURCE ENVIRONMENT . ~/.dsadm ## CHANGE TO Directory Containing the VOC cd $DSHOME ## GET PROJECT LIST INTO ARRAY set -A MY_ARRAY $(dssh "SELECT PATH FMT '60L' \ FROM UV.ACCOUNT \ WHERE @ID NOT IN ('UV', 'u...

Thanks. I had to change uv to uvsh because of load errors. But that works awesome.

Thanks.

It looks like UV.account stores this info. I can see the projects and paths when I do a strings on this file. Is there any other place that is more readable to get this information? Is there a command that can be run to get this information? I can run dsjob -lprojects, but this only lists the projec...

That is what I tried track_star. It gives error messages about PX not running for that interface and the jobs timeout. It may work for MPP and extending the PX environment, but it does not for SMP. If it does work for SMP, I don't know how to extend as the documentation does not explain this functio...

Good post.

Thanks.

With Oracle (tnsname.ora) and Sybase (interfaces) on Unix I can configure what specific networks the database will start listeners for. I can configure the client software for Oracle (tnsname.ora) and Sybase (sql.ini) to use a specific network interface. That is the capability I would like.

I would be happy with the ability to just round robin the interfaces by choosing the appropriate .apt file. However, I get an error saying that software is not running on that network. Even though all the networks are for the same server.

Thanks for hijacking the thread and not answering my question.

I'm not sure what you mean by "network interfaces" in this context. SMP to me implies one machine with multiple CPUs. A single machine can have multiple network interfaces. For example, you configure many database systems to use multiple network interfaces on one physical node. You do this...

Hello,

I have multiple network interfaces and would like to configure different interfaces for each node in the APT_CONFIG_FILE.

How do I configure for multiple network interfaces on SMP?

When I change the fastname to one of the other interfaces, jobs abort with timeout messages.

Thanks