Regarding Oracle connectivity issues
So I am assuming you have 2 tnsnames, one in each Oracle_Home directory. Have you tried just opening a sqlplus connection and see if you could connect to the Oracle9i db. I would also try opening sqlplus from the Start->Run so as to also see which one it brings up…the 7 or 9 version. I [...]
View Answer
| November 26, 2005 12:22 PM
Database, DB2, Oracle, SQL, Windows
So I am assuming you have 2 tnsnames, one in each Oracle_Home directory. Have you tried just opening a sqlplus connection and see if you could connect to the Oracle9i db. I would also try opening sqlplus from the Start->Run so as to also see which one it brings up…the 7 or 9 version. I [...]
View Answer
| November 26, 2005 12:22 PM
Database, DB2, Oracle, SQL, Windows
Indexing on Large table
Everything else being equal, the response times for querying these two tables individually should be nearly identical. The difference would only be whatever time it takes to package the additional 50 fields for routing. That will take some time, probably uncalculable per row; But if you are returning 1,000,000 or so rows, that might be [...]
View Answer
| November 23, 2005 10:03 AM
Database, DB2, Oracle
Everything else being equal, the response times for querying these two tables individually should be nearly identical. The difference would only be whatever time it takes to package the additional 50 fields for routing. That will take some time, probably uncalculable per row; But if you are returning 1,000,000 or so rows, that might be [...]
View Answer
| November 23, 2005 10:03 AM
Database, DB2, Oracle
SQL Server 2005 adoption
I only just installed the SQL Server 2005 a few days ago, and haven’t had very much time to look at the setups yet. However it seems to me, that the Management Studio works quite better and is at the first look very easy to use. The basic functions for backing up, attaching and altering [...]
View Answer
| November 23, 2005 4:31 AM
Access, Database, DataCenter, DB2, Desktops, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Windows
I only just installed the SQL Server 2005 a few days ago, and haven’t had very much time to look at the setups yet. However it seems to me, that the Management Studio works quite better and is at the first look very easy to use. The basic functions for backing up, attaching and altering [...]
View Answer
| November 23, 2005 4:31 AM
Access, Database, DataCenter, DB2, Desktops, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Windows
Migration from OS/390 to Z/OS V1.6 with CSP
I am not 100 percent sure but I do not think migration from 2.10 to 1.6 is possible. I thought 1.4 was the last release that 2.10 could migrate to.
View Answer
| November 22, 2005 10:29 AM
390, DB2, Mainframe, zSeries
I am not 100 percent sure but I do not think migration from 2.10 to 1.6 is possible. I thought 1.4 was the last release that 2.10 could migrate to.
View Answer
| November 22, 2005 10:29 AM
390, DB2, Mainframe, zSeries
Stop bit problem: USB to Serial Converter attached to motion controller, unable to set for 7-E-2
This may seem like a silly response, but since the 7-E-2 setting is the default, can it be changed? While I find dealing with serial communications on PLCs to be a pain in the butt, I’ve never had to deal with odd settings like that one. Good luck!
View Answer
| November 21, 2005 7:21 AM
3Com, Active Directory, ActiveX, Administration, Apache, Automated, Availability, BASIC, Benchmarking, Business Objects, C, Cabling, Cape Clear Cape Connect, Career development, Cisco, Clustering, Cognos, Crystal Reports, Data analysis, Data Junction, Data management and storage, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Dell, Desktop management applications, Desktops, Development, DHCP, Distribution/logistics applications, DNS, Enterprise Desktop, Ethernet, Fault isolation, Fax and print management, FDDI, File, Frame Relay, Functional, H.323, Hardware, Hardware selection and management, Hewlett-Packard, Hewlett-Packard Application Server, Hubs, Hyperion, IBM, Informatica, Information Builders, Interoperability, Lifecycle development, Linux, Lotus Domino, Management, Manufacturing applications, Microprocessors, Microsoft Systems Management Server, Microsoft Windows, Migrations and upgrades, Monitoring, NCR, NCR/Teradata, Network applications management, Network connectivity, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NIC, Novell IPX/SPX, Oracle, OS, Performance and availability, Performance management, Performance/Load, Ping, Power management, Printers, Programming Languages, Protocol analysis, Remote management, Routers, SAP, SAS Institute, Security, Servers, Software, Software testing, Software testing tools, SPSS, SQL Server, standards, Storage, Switches, Systems management software, TCP, Tech support, Thermal controls
This may seem like a silly response, but since the 7-E-2 setting is the default, can it be changed? While I find dealing with serial communications on PLCs to be a pain in the butt, I’ve never had to deal with odd settings like that one. Good luck!
View Answer
| November 21, 2005 7:21 AM
3Com, Active Directory, ActiveX, Administration, Apache, Automated, Availability, BASIC, Benchmarking, Business Objects, C, Cabling, Cape Clear Cape Connect, Career development, Cisco, Clustering, Cognos, Crystal Reports, Data analysis, Data Junction, Data management and storage, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Dell, Desktop management applications, Desktops, Development, DHCP, Distribution/logistics applications, DNS, Enterprise Desktop, Ethernet, Fault isolation, Fax and print management, FDDI, File, Frame Relay, Functional, H.323, Hardware, Hardware selection and management, Hewlett-Packard, Hewlett-Packard Application Server, Hubs, Hyperion, IBM, Informatica, Information Builders, Interoperability, Lifecycle development, Linux, Lotus Domino, Management, Manufacturing applications, Microprocessors, Microsoft Systems Management Server, Microsoft Windows, Migrations and upgrades, Monitoring, NCR, NCR/Teradata, Network applications management, Network connectivity, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NIC, Novell IPX/SPX, Oracle, OS, Performance and availability, Performance management, Performance/Load, Ping, Power management, Printers, Programming Languages, Protocol analysis, Remote management, Routers, SAP, SAS Institute, Security, Servers, Software, Software testing, Software testing tools, SPSS, SQL Server, standards, Storage, Switches, Systems management software, TCP, Tech support, Thermal controls
sql query
I’m assuming you have a situation like this: Policy: PolicyNumber CHAR(…), NameId INTEGER, … Name: NameId INTEGER, Name VARCHAR(…), … Use this query: WITH matches AS( SELECT nameId, COUNT(*) FROM policy GROUP BY nameId HAVING COUNT(*)>1) SELECT n.name, p.policyNumber FROM matches m, name n, policy p WHERE m.nameId=n.nameId AND m.nameId=p.nameId — Sheldon Linker Linker Systems, [...]
View Answer
| November 18, 2005 1:42 PM
Database, DB2, Oracle
I’m assuming you have a situation like this: Policy: PolicyNumber CHAR(…), NameId INTEGER, … Name: NameId INTEGER, Name VARCHAR(…), … Use this query: WITH matches AS( SELECT nameId, COUNT(*) FROM policy GROUP BY nameId HAVING COUNT(*)>1) SELECT n.name, p.policyNumber FROM matches m, name n, policy p WHERE m.nameId=n.nameId AND m.nameId=p.nameId — Sheldon Linker Linker Systems, [...]
View Answer
| November 18, 2005 1:42 PM
Database, DB2, Oracle
SQL Query Perfomance Issue.
Wow! This one is just a treasure chest of things that take time. Rather than go through the whole thing, which could take an hour, I’ll give you some pointers: (1) Don’t compare using UPPER or NVL unless you have to. Consider NOT NULL fields, field stored in upper case, a second field set up [...]
View Answer
| November 18, 2005 11:30 AM
Automated, ERP, Oracle, Performance/Load, Software testing, Software testing tools, Windows
Wow! This one is just a treasure chest of things that take time. Rather than go through the whole thing, which could take an hour, I’ll give you some pointers: (1) Don’t compare using UPPER or NVL unless you have to. Consider NOT NULL fields, field stored in upper case, a second field set up [...]
View Answer
| November 18, 2005 11:30 AM
Automated, ERP, Oracle, Performance/Load, Software testing, Software testing tools, Windows
Memory (helpfield) usage in Microsoft Access with VBA
This is typical: ask a question, read it again, think it over and answer your own question. Since every user is running on his own desktop computer, he (and she) uses the memory of his desktop, not any shared memory on the server. However, what about a helpfield that is defined as Public ?
View Answer
| November 17, 2005 8:13 AM
Access, Database, DB2, Oracle, VBA
This is typical: ask a question, read it again, think it over and answer your own question. Since every user is running on his own desktop computer, he (and she) uses the memory of his desktop, not any shared memory on the server. However, what about a helpfield that is defined as Public ?
View Answer
| November 17, 2005 8:13 AM
Access, Database, DB2, Oracle, VBA
Database Diagram Tool
Depends on what you already have on your PC. If you have Microsoft Visio, it will work. Also If you are using Sql Server 2000 for you DB, it has a diagram tool in it. Look at the apps you have before you try to find a third party program.
View Answer
| November 16, 2005 8:24 AM
Data analysis, Data warehousing applications, Database, DB2, Oracle
Depends on what you already have on your PC. If you have Microsoft Visio, it will work. Also If you are using Sql Server 2000 for you DB, it has a diagram tool in it. Look at the apps you have before you try to find a third party program.
View Answer
| November 16, 2005 8:24 AM
Data analysis, Data warehousing applications, Database, DB2, Oracle
Delete maximum records in a table
Although there are a number of ways to do this in a single SQL statement, it’s best to use a cursor loop, since any such SQL statement would rely on order of execution, and that’s called a “pornographic specification”, since it can be version-dependent. Here’s how I’d do it: Assuming: CREATE TABLE myTable( major INTEGER, [...]
View Answer
| November 16, 2005 1:32 AM
Database, DB2, Oracle
Although there are a number of ways to do this in a single SQL statement, it’s best to use a cursor loop, since any such SQL statement would rely on order of execution, and that’s called a “pornographic specification”, since it can be version-dependent. Here’s how I’d do it: Assuming: CREATE TABLE myTable( major INTEGER, [...]
View Answer
| November 16, 2005 1:32 AM
Database, DB2, Oracle
sql query
The following rudimentary script will show you the basics. You can expand on this to show what you need. select b.sid, b.username, a.sql_text from v$sqlarea a, v$session b where a.address=b.sql_address Oracle’s Enterprise Manager ‘Top Sessions’, ‘Top SQL’ provides a good gui interface.
View Answer
| November 15, 2005 1:05 PM
Database, DB2, Oracle
The following rudimentary script will show you the basics. You can expand on this to show what you need. select b.sid, b.username, a.sql_text from v$sqlarea a, v$session b where a.address=b.sql_address Oracle’s Enterprise Manager ‘Top Sessions’, ‘Top SQL’ provides a good gui interface.
View Answer
| November 15, 2005 1:05 PM
Database, DB2, Oracle
database down
Have a look in the oracle/admin/[sid]/bdump directory at the alert_[sid].log file. Should see entries of when a database is started or shutdown.
View Answer
| November 15, 2005 11:09 AM
Database, DB2, Oracle
Have a look in the oracle/admin/[sid]/bdump directory at the alert_[sid].log file. Should see entries of when a database is started or shutdown.
View Answer
| November 15, 2005 11:09 AM
Database, DB2, Oracle
sqlplus killed
I seem to remember this behaviour when you don’t have the correct environment set up. $ORACLE_HOME amongst others must be set up. Talk to your DBA, there should be a script to set up all your necessary environment.
View Answer
| November 14, 2005 4:05 AM
Database, DB2, Oracle
I seem to remember this behaviour when you don’t have the correct environment set up. $ORACLE_HOME amongst others must be set up. Talk to your DBA, there should be a script to set up all your necessary environment.
View Answer
| November 14, 2005 4:05 AM
Database, DB2, Oracle
Effect of DB migration on Interfaces
SAP has a OS/DB migrations guide/checklist and a go-live check that has to be performed before you go live on the new system. I have done this several time for different DB and OS. Seeing that this will be a hetrogenius migration you can run the R/3 Inst. on the DEV system and export the [...]
View Answer
| November 13, 2005 4:42 PM
Basis, Database, DB2, Oracle, Upgrades / implementations
SAP has a OS/DB migrations guide/checklist and a go-live check that has to be performed before you go live on the new system. I have done this several time for different DB and OS. Seeing that this will be a hetrogenius migration you can run the R/3 Inst. on the DEV system and export the [...]
View Answer
| November 13, 2005 4:42 PM
Basis, Database, DB2, Oracle, Upgrades / implementations
QsnBeep
It should write the beep command to the 5250 session immediately. So if you called it, delayed a few seconds, and then called it again it would beep twice. You could test it with a CL program that calls QsnBeep twice and performs a DLYJOB in between.
View Answer
| November 11, 2005 9:04 AM
AS/400, DataCenter, DB2 Universal Database, Development, ERP, RPG, Tech support
It should write the beep command to the 5250 session immediately. So if you called it, delayed a few seconds, and then called it again it would beep twice. You could test it with a CL program that calls QsnBeep twice and performs a DLYJOB in between.
View Answer
| November 11, 2005 9:04 AM
AS/400, DataCenter, DB2 Universal Database, Development, ERP, RPG, Tech support
DFSMSdss / ADRDSSU (Dump Full or Copy Full)
Robert, Are you sure you even need these files. By the sound of the vol ser name it is a work volume used for temporary datasets. Maybe you just need to mount it as private and most of the files would be removed on their own. Anyway, I use these control cards : Use the [...]
View Answer
| November 10, 2005 12:17 PM
390, Backup & recovery, DB2, IBM, Mainframe, Storage
Robert, Are you sure you even need these files. By the sound of the vol ser name it is a work volume used for temporary datasets. Maybe you just need to mount it as private and most of the files would be removed on their own. Anyway, I use these control cards : Use the [...]
View Answer
| November 10, 2005 12:17 PM
390, Backup & recovery, DB2, IBM, Mainframe, Storage
layer 2 & layer 3 switch
Hi, 1) a layer 2 switch routes traffic based on the MAC address. 2) a layer 3 switch routes traffic based on the IP address. TechTarget has a great web site for definitions of terms like this, and I encourage you to use it often. The link is: http://whatis.techtarget.com/ At this site, search on the [...]
View Answer
| November 10, 2005 10:59 AM
Access control, Application security, Availability, backdoors, Bandwidth, Biometrics, Browsers, Cabling, Cisco, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, Hardware, Hubs, human factors, Identity & Access Management, Incident response, Instant Messaging, Interoperability, Intrusion management, Network monitoring, Network protocols, Network security, Networking, patching, PEN testing, Performance management, Ping, Platform Security, Policies, provisioning, Risk management, Routers, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Software, Spyware, SSL/TLS, Switches, Tech support, Trojans, Viruses, VoIP, VPN, vulnerability management, Web security, Wireless, worms
Hi, 1) a layer 2 switch routes traffic based on the MAC address. 2) a layer 3 switch routes traffic based on the IP address. TechTarget has a great web site for definitions of terms like this, and I encourage you to use it often. The link is: http://whatis.techtarget.com/ At this site, search on the [...]
View Answer
| November 10, 2005 10:59 AM
Access control, Application security, Availability, backdoors, Bandwidth, Biometrics, Browsers, Cabling, Cisco, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, Hardware, Hubs, human factors, Identity & Access Management, Incident response, Instant Messaging, Interoperability, Intrusion management, Network monitoring, Network protocols, Network security, Networking, patching, PEN testing, Performance management, Ping, Platform Security, Policies, provisioning, Risk management, Routers, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Software, Spyware, SSL/TLS, Switches, Tech support, Trojans, Viruses, VoIP, VPN, vulnerability management, Web security, Wireless, worms
Connecting to the Database
Have you verified that you have the latest DAO drivers? For development purposes could you make a start with ODBC?
View Answer
| November 10, 2005 4:38 AM
Automated, Data analysis, Database, DataCenter, DB2, DB2 Universal Database, Development, Oracle, Software Quality Assurance, Software testing, Software testing tools, SQL
Have you verified that you have the latest DAO drivers? For development purposes could you make a start with ODBC?
View Answer
| November 10, 2005 4:38 AM
Automated, Data analysis, Database, DataCenter, DB2, DB2 Universal Database, Development, Oracle, Software Quality Assurance, Software testing, Software testing tools, SQL
Name that computer?
Gosh! Ok, I’m open to speculation – since it’s clear that you’re inviting such things…. Could it be an early Data General machine? By way of identification, are all of the disk drive cables a bundle of twisted pair cables in a ribbon, which look kind of like a newer SCSI cable, but larger? What [...]
View Answer
| November 10, 2005 2:00 AM
390, AS/400, DB2, Hardware, Hewlett-Packard Application Server, Linux, Mainframe, Servers
Gosh! Ok, I’m open to speculation – since it’s clear that you’re inviting such things…. Could it be an early Data General machine? By way of identification, are all of the disk drive cables a bundle of twisted pair cables in a ribbon, which look kind of like a newer SCSI cable, but larger? What [...]
View Answer
| November 10, 2005 2:00 AM
390, AS/400, DB2, Hardware, Hewlett-Packard Application Server, Linux, Mainframe, Servers
Java and Oracle
I assume from your question, that you’re not using Java within Oracle. You’re “just” using JDBC to access Oracle. In case of performance problems, it important that you identify the wait causes. Is it the DB that’s busy, or your frontend application that’s slowing things down – or a combination. Reasons for performance problems are [...]
View Answer
| November 9, 2005 11:34 AM
Database, DB2, Oracle, SQL
I assume from your question, that you’re not using Java within Oracle. You’re “just” using JDBC to access Oracle. In case of performance problems, it important that you identify the wait causes. Is it the DB that’s busy, or your frontend application that’s slowing things down – or a combination. Reasons for performance problems are [...]
View Answer
| November 9, 2005 11:34 AM
Database, DB2, Oracle, SQL
