Oracle DataBase Connectivity
Pls Save Me I am Waiting
View Answer
| February 22, 2005 7:43 AM
Database issues, Very Large Databases
Pls Save Me I am Waiting
View Answer
| February 22, 2005 7:43 AM
Database issues, Very Large Databases
Need an Exchange migration guru
Hi Christine, I certainly do not claim to be an exchange Guru. But I know a man who is. His name is Hutton and was working for a company called BSG. He Moved our Exchange system from 5.5 to 2000 with no problems. If you can find him he would be great.
View Answer
| February 20, 2005 3:30 PM
Administration, Application management, Backup, Client management, Clustering/High availability, Database issues, DataManagement, Disaster Recovery, Exchange, Exchange 2000, Exchange 2003, Exchange 5.5, Exchange Server ActiveSync, Installation, Maintenance, Migration, Outlook, Outlook Mobile Access, Storage management, Tech support
Hi Christine, I certainly do not claim to be an exchange Guru. But I know a man who is. His name is Hutton and was working for a company called BSG. He Moved our Exchange system from 5.5 to 2000 with no problems. If you can find him he would be great.
View Answer
| February 20, 2005 3:30 PM
Administration, Application management, Backup, Client management, Clustering/High availability, Database issues, DataManagement, Disaster Recovery, Exchange, Exchange 2000, Exchange 2003, Exchange 5.5, Exchange Server ActiveSync, Installation, Maintenance, Migration, Outlook, Outlook Mobile Access, Storage management, Tech support
Database and Web Server Technology Choices for Small Database Application
Time and Money – it is always about time and money. If you have the time for the learning curve then use L_A_M_P [Linux, Apache, MySQL, Perl/PHP] lowest cost overall but the most time consuming it you are not already a Linux user. Easily handle many more users, fast web services, thousands of frontend programs [...]
View Answer
| February 20, 2005 9:22 AM
Database, DB2, Development, Oracle, Web development tools
Time and Money – it is always about time and money. If you have the time for the learning curve then use L_A_M_P [Linux, Apache, MySQL, Perl/PHP] lowest cost overall but the most time consuming it you are not already a Linux user. Easily handle many more users, fast web services, thousands of frontend programs [...]
View Answer
| February 20, 2005 9:22 AM
Database, DB2, Development, Oracle, Web development tools
moving program code between lpars.
If you are running GRS you can catalog test and prod files on whichever lpar and do a direct copy; otherwise copy from test to temp, then copy temp to production and delete temp. You can use vol=ser pointers or catalog temp on both lpars (as long as you are not doing updates to temp [...]
View Answer
| February 17, 2005 11:56 AM
Application security, Auditing, Database, DataCenter, Encryption, Exchange, Information risk management, Instant Messaging, Secure Coding
If you are running GRS you can catalog test and prod files on whichever lpar and do a direct copy; otherwise copy from test to temp, then copy temp to production and delete temp. You can use vol=ser pointers or catalog temp on both lpars (as long as you are not doing updates to temp [...]
View Answer
| February 17, 2005 11:56 AM
Application security, Auditing, Database, DataCenter, Encryption, Exchange, Information risk management, Instant Messaging, Secure Coding
Data base encryption
The IBM Custom Technology Center in Rochester has developed wrappers to the encryption API’s. I do believe that you need the cryptographic card installed … but check with CTC for sure. CTC Contact is Mark Even – (507)253-1313 / even@us.ibm.com
View Answer
| February 11, 2005 12:33 PM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding
The IBM Custom Technology Center in Rochester has developed wrappers to the encryption API’s. I do believe that you need the cryptographic card installed … but check with CTC for sure. CTC Contact is Mark Even – (507)253-1313 / even@us.ibm.com
View Answer
| February 11, 2005 12:33 PM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding
unrecognized data base format
Jet DB Engine conflicts. The underlying Database engine for Visual Basic is Jet 4.0 (Visual Studio 6.0). this is also the underlying engine for ‘Microsoft Access 2000′ as shipped and if patched up to date. As patched it is also the same for ‘Microsoft AccessXP’. PROBABLE – different patch levels between the three. Start with [...]
View Answer
| January 31, 2005 8:38 AM
Microsoft Access, Visual Basic
Jet DB Engine conflicts. The underlying Database engine for Visual Basic is Jet 4.0 (Visual Studio 6.0). this is also the underlying engine for ‘Microsoft Access 2000′ as shipped and if patched up to date. As patched it is also the same for ‘Microsoft AccessXP’. PROBABLE – different patch levels between the three. Start with [...]
View Answer
| January 31, 2005 8:38 AM
Microsoft Access, Visual Basic
Exchange 2000 server: 1-2 clients receiving Outlook error “0x800CCC0F”
Have you researched this at all on Tech Net? At the risk of duplicating information you already have, the drror code “0x800CCC0F” resolves to a dropped connection of some sort. The MS KB article here (KB 813514): http://support.microsoft.com/default.aspx?scid=kb;en-us;813514 Are you running IIS? If so, this articlew may shed some light on what is happening (although [...]
View Answer
| January 31, 2005 8:34 AM
Administration, Client management, Database issues, Exchange, Exchange 2000, Maintenance, Networking, Outlook, Tech support
Have you researched this at all on Tech Net? At the risk of duplicating information you already have, the drror code “0x800CCC0F” resolves to a dropped connection of some sort. The MS KB article here (KB 813514): http://support.microsoft.com/default.aspx?scid=kb;en-us;813514 Are you running IIS? If so, this articlew may shed some light on what is happening (although [...]
View Answer
| January 31, 2005 8:34 AM
Administration, Client management, Database issues, Exchange, Exchange 2000, Maintenance, Networking, Outlook, Tech support
Microsoft Access: Append Query problem
If the key field is autonumber, then in your append statement do not include that field. When you run the query, Access will automatically increment the number in that field.
View Answer
| January 26, 2005 10:46 AM
Access, Microsoft Access
If the key field is autonumber, then in your append statement do not include that field. When you run the query, Access will automatically increment the number in that field.
View Answer
| January 26, 2005 10:46 AM
Access, Microsoft Access
Deleting journal receivers
Try this. I use it in a SBMJOB CL *PGM that clears a library with *JRNRCV CHGJOB INQMSGRPY(*SYSRPYL) ADDRPYLE SEQNBR(999) MSGID(CPA7025) CMPDTA(&LIB 11) + RPY(I) Delete receivers…. RMVRPYLE SEQNBR(999)
View Answer
| January 18, 2005 11:21 AM
Backup & recovery, Database Management Systems, DB2, DB2 administration, Hardware, i5, iSeries, OS/400, Performance/Tuning, Servers, tips and tricks, Tools
Try this. I use it in a SBMJOB CL *PGM that clears a library with *JRNRCV CHGJOB INQMSGRPY(*SYSRPYL) ADDRPYLE SEQNBR(999) MSGID(CPA7025) CMPDTA(&LIB 11) + RPY(I) Delete receivers…. RMVRPYLE SEQNBR(999)
View Answer
| January 18, 2005 11:21 AM
Backup & recovery, Database Management Systems, DB2, DB2 administration, Hardware, i5, iSeries, OS/400, Performance/Tuning, Servers, tips and tricks, Tools
Restricted access to win XP professional
You’d be best off if your Win2K server is upgraded to a domain controller using ‘dcpromo’ at the command line. Then you would add all of your XP machines to the domain you have created and restrict access on ALL of the machines according to a single set of users which exist within active directory… [...]
View Answer
| December 28, 2004 6:16 PM
Administration, Application security, Compliance, CRM, Database, DataCenter, Desktop management applications, DHCP, Disaster Recovery, DNS, Encryption, Exchange, Firewalls, Forensics, Help Desk, Implementation, Incident response, Information risk management, Instant Messaging, Intrusion management, Management, Network monitoring, Network security, Networking, Networking services, Physical security, Policies, Remote management, Remote users, Risk management, Secure Coding, Security, Security management, Security Program Management, Servers, System utilities, Tech support, Third-party services, VPN, Windows, Windows 2000 Server, Wireless
You’d be best off if your Win2K server is upgraded to a domain controller using ‘dcpromo’ at the command line. Then you would add all of your XP machines to the domain you have created and restrict access on ALL of the machines according to a single set of users which exist within active directory… [...]
View Answer
| December 28, 2004 6:16 PM
Administration, Application security, Compliance, CRM, Database, DataCenter, Desktop management applications, DHCP, Disaster Recovery, DNS, Encryption, Exchange, Firewalls, Forensics, Help Desk, Implementation, Incident response, Information risk management, Instant Messaging, Intrusion management, Management, Network monitoring, Network security, Networking, Networking services, Physical security, Policies, Remote management, Remote users, Risk management, Secure Coding, Security, Security management, Security Program Management, Servers, System utilities, Tech support, Third-party services, VPN, Windows, Windows 2000 Server, Wireless
vpn through s-box firewall of checkpoint
Try opening ports 1723 and 500 on your firewall with port forwarding to the IP of the NIC in your server that is configured for VPN. Make sure your SMB2003 is set up for VPN whether it be PPTP or L2TP over IPSEC. Make sure your fire is set to allow any incoming connections. make [...]
View Answer
| June 29, 2012 11:33 AM
Administration, Application security, Architecture/Design, Database, Documentation, Encryption, Exchange, Features/Functionality, Firewalls, Forensics, Help Desk, Implementation, Incident response, Installation, Instant Messaging, Intrusion management, IT architecture, Knowledge management applications, Network security, Planning, Secure Coding, Security, Security management, Security products, Service and support, Spam, VPN, Wireless
Try opening ports 1723 and 500 on your firewall with port forwarding to the IP of the NIC in your server that is configured for VPN. Make sure your SMB2003 is set up for VPN whether it be PPTP or L2TP over IPSEC. Make sure your fire is set to allow any incoming connections. make [...]
View Answer
| June 29, 2012 11:33 AM
Administration, Application security, Architecture/Design, Database, Documentation, Encryption, Exchange, Features/Functionality, Firewalls, Forensics, Help Desk, Implementation, Incident response, Installation, Instant Messaging, Intrusion management, IT architecture, Knowledge management applications, Network security, Planning, Secure Coding, Security, Security management, Security products, Service and support, Spam, VPN, Wireless
Triggers
QADBXTRIGB – but you cannot use ezview on it.
View Answer
| December 27, 2004 2:52 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
QADBXTRIGB – but you cannot use ezview on it.
View Answer
| December 27, 2004 2:52 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
Microsoft: Active Directory Migration Tool (ADMT)
Hello, You can refer to the information contained in this tech note to assist you with both the planning and migration steps to move all or some of your current NT 4.0 users and computers. http://www.windowsitpro.com/WindowsMigration/Article/ArticleID/4692/WindowsMigration_4692.html Good Luck!
View Answer
| December 22, 2004 3:04 PM
Active Directory, Administration, Application management, Application software, Backup, Client management, Clustering/High availability, Database issues, DataCenter, DataManagement, DHCP, Disaster Recovery, DNS, Exchange, Exchange 2003, Exchange 5.5, Help Desk, Installation, LDAP, Lotus Domino, Maintenance, Microsoft Windows, Migration, Networking services, Outlook, Software testing, Software testing tools, Storage management, Tech support, Third-party services, Vendor support
Hello, You can refer to the information contained in this tech note to assist you with both the planning and migration steps to move all or some of your current NT 4.0 users and computers. http://www.windowsitpro.com/WindowsMigration/Article/ArticleID/4692/WindowsMigration_4692.html Good Luck!
View Answer
| December 22, 2004 3:04 PM
Active Directory, Administration, Application management, Application software, Backup, Client management, Clustering/High availability, Database issues, DataCenter, DataManagement, DHCP, Disaster Recovery, DNS, Exchange, Exchange 2003, Exchange 5.5, Help Desk, Installation, LDAP, Lotus Domino, Maintenance, Microsoft Windows, Migration, Networking services, Outlook, Software testing, Software testing tools, Storage management, Tech support, Third-party services, Vendor support
How to purge records from the database?
Aghhhhhhh. You said the D word. If and when possible you should avoid using the delete function. Try to create a field to mark the records you do not think you need (you may need them again) and redesign your views and stored procs to filter out the marked records. But in all seriousness try [...]
View Answer
| December 21, 2004 5:02 PM
Database, DB2, Implementation, Oracle, SQL, SQL Server, T-SQL, Tech support
Aghhhhhhh. You said the D word. If and when possible you should avoid using the delete function. Try to create a field to mark the records you do not think you need (you may need them again) and redesign your views and stored procs to filter out the marked records. But in all seriousness try [...]
View Answer
| December 21, 2004 5:02 PM
Database, DB2, Implementation, Oracle, SQL, SQL Server, T-SQL, Tech support
Stored Procedure Error
I am not able to run this but purely looking at the syntax it may be as simple as requiring a ‘;’ after your final FETCH statement.
View Answer
| December 17, 2004 6:11 AM
Application software, Availability, DB2 Everyplace, Development, IBM, Instant Messaging, Java, Migration, Modeling, Normalization, Performance/Tuning, Servers, WebSphere Studio
I am not able to run this but purely looking at the syntax it may be as simple as requiring a ‘;’ after your final FETCH statement.
View Answer
| December 17, 2004 6:11 AM
Application software, Availability, DB2 Everyplace, Development, IBM, Instant Messaging, Java, Migration, Modeling, Normalization, Performance/Tuning, Servers, WebSphere Studio
Monitor Internet Bandwidth
Use the ISA server built-in report utility, where you can define different reports to be run on f.ex. daily and/or monthly basis. ISA server will supply you with a number of reports including the one that you want. Tip: Run the report generator under a separate service account and not with your own user account, [...]
View Answer
| November 29, 2004 2:49 AM
Active Directory, Administration, Application management, Auditing, Availability, Backup, Backup & recovery, Bandwidth, Benchmarking, Bind, BroadVision, Business Objects, Call Centers, Clarify Inc., CLB, Client management, Clustering/High availability, Component Load Balancing, Content filtering, Corporate portal applications, Customer relationship management applications, Data analysis, Data center operations, Data mining/analysis, Data warehousing/Business intelligence, Database Management Systems, DataCenter, Datacenter Server, DB2 administration, Desktop security, Desktops, DHCP, Distributed File System, DNS, E-business, E-mail applications, ERP, Exchange, Exchange 2000, Exchange 2003, Exchange 5.5, Exchange Server ActiveSync, FAT and NTFS, Fault isolation, Firewalls, General Directories, Graphical User Interfaces, Handheld, Hardware, Help Desk, Information risk management, Integration/Connectivity, Intel servers, IT architecture, Knowledge management applications, Licensing, Lotus Domino, Mail protocols, Maintenance, Major Vendors, Microsoft Internet Information Server, Microsoft Windows, Monitoring, Netscape Mail, Network applications management, Network management software, Network monitoring, Network requirements, Network testing, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Operating systems, Outlook, PC/Windows Connectivity, Performance management, Performance/Tuning, Planning, Policies, POP3, Protocol analysis, Remote management, Reporting, ROI & cost justification, Routers, S/MIME, Security, Security management, Security products, Sendmail, Server consolidation, Server management, Server-based/Thin-client computing, Servers, Services, Software, Software distribution, Software Quality Assurance, Spam, Storage, System monitoring, System utilities, Tech support, Technical support, Third-party services, Vendor support, Virus protection, Web services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance, Windows on Intel, Windows Server 2003
Use the ISA server built-in report utility, where you can define different reports to be run on f.ex. daily and/or monthly basis. ISA server will supply you with a number of reports including the one that you want. Tip: Run the report generator under a separate service account and not with your own user account, [...]
View Answer
| November 29, 2004 2:49 AM
Active Directory, Administration, Application management, Auditing, Availability, Backup, Backup & recovery, Bandwidth, Benchmarking, Bind, BroadVision, Business Objects, Call Centers, Clarify Inc., CLB, Client management, Clustering/High availability, Component Load Balancing, Content filtering, Corporate portal applications, Customer relationship management applications, Data analysis, Data center operations, Data mining/analysis, Data warehousing/Business intelligence, Database Management Systems, DataCenter, Datacenter Server, DB2 administration, Desktop security, Desktops, DHCP, Distributed File System, DNS, E-business, E-mail applications, ERP, Exchange, Exchange 2000, Exchange 2003, Exchange 5.5, Exchange Server ActiveSync, FAT and NTFS, Fault isolation, Firewalls, General Directories, Graphical User Interfaces, Handheld, Hardware, Help Desk, Information risk management, Integration/Connectivity, Intel servers, IT architecture, Knowledge management applications, Licensing, Lotus Domino, Mail protocols, Maintenance, Major Vendors, Microsoft Internet Information Server, Microsoft Windows, Monitoring, Netscape Mail, Network applications management, Network management software, Network monitoring, Network requirements, Network testing, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Operating systems, Outlook, PC/Windows Connectivity, Performance management, Performance/Tuning, Planning, Policies, POP3, Protocol analysis, Remote management, Reporting, ROI & cost justification, Routers, S/MIME, Security, Security management, Security products, Sendmail, Server consolidation, Server management, Server-based/Thin-client computing, Servers, Services, Software, Software distribution, Software Quality Assurance, Spam, Storage, System monitoring, System utilities, Tech support, Technical support, Third-party services, Vendor support, Virus protection, Web services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance, Windows on Intel, Windows Server 2003
Database Project Definiton
With that size of database and access needed, go with teradata database.
View Answer
| November 28, 2004 11:40 AM
Database architectures, Database design
With that size of database and access needed, go with teradata database.
View Answer
| November 28, 2004 11:40 AM
Database architectures, Database design
Moving spool files from one AS400 to another
I am more familar with the SNDNETSPLF command which has a DTAFMT parameter. The value *ALLDATA will retain all the attributes of the spool file except creation information. The user id and creation date/time are new because you are actually sending a created copy of the original spool file to a user on a target [...]
View Answer
| November 12, 2004 10:28 AM
AS/400, Backup & recovery, DB2, DB2 administration, DB2 Implementation, Hardware, Installation/Upgrades, Migration, Tech support, UDB for iSeries/i5
I am more familar with the SNDNETSPLF command which has a DTAFMT parameter. The value *ALLDATA will retain all the attributes of the spool file except creation information. The user id and creation date/time are new because you are actually sending a created copy of the original spool file to a user on a target [...]
View Answer
| November 12, 2004 10:28 AM
AS/400, Backup & recovery, DB2, DB2 administration, DB2 Implementation, Hardware, Installation/Upgrades, Migration, Tech support, UDB for iSeries/i5
How do I check for changes in a database on insert / update?
Please provide more detail about how updates will be handled to the database so I can give you a better answer. For example, what is the threshold for accuracy? If you want 100% accuracy you must check each field in each row 1-by-1. If there is a “low” risk that other applications would modify the [...]
View Answer
| October 26, 2004 5:11 PM
Microsoft Access, SQL Server, VB.NET, Visual Basic
Please provide more detail about how updates will be handled to the database so I can give you a better answer. For example, what is the threshold for accuracy? If you want 100% accuracy you must check each field in each row 1-by-1. If there is a “low” risk that other applications would modify the [...]
View Answer
| October 26, 2004 5:11 PM
Microsoft Access, SQL Server, VB.NET, Visual Basic
Oracle In Linux
Pretty broad question, but for installation issues with Oracle on Linux, I have found this site very helpful if used with the installation notes as well as some the documents available on Metalink. Good Luck http://www.puschitz.com/OracleOnLinux.shtml
View Answer
| October 15, 2004 10:15 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS
Pretty broad question, but for installation issues with Oracle on Linux, I have found this site very helpful if used with the installation notes as well as some the documents available on Metalink. Good Luck http://www.puschitz.com/OracleOnLinux.shtml
View Answer
| October 15, 2004 10:15 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS
