data encryption/decryption
I can’t help with the API problems, but since you mention you’re encrypting database records, you might want to look at technology that transparently encrypts databases with field level granularity. A good place to start is with Protegrity who do just that. Let me know if you need further information. All the best, Johan
View Answer
| January 11, 2006 3:27 PM
Application development, Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding
I can’t help with the API problems, but since you mention you’re encrypting database records, you might want to look at technology that transparently encrypts databases with field level granularity. A good place to start is with Protegrity who do just that. Let me know if you need further information. All the best, Johan
View Answer
| January 11, 2006 3:27 PM
Application development, Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding
read only user
Try granting select on dba_source.
View Answer
| January 11, 2006 10:36 AM
Database, DB2, Oracle, SQL
Try granting select on dba_source.
View Answer
| January 11, 2006 10:36 AM
Database, DB2, Oracle, SQL
problem related paper size (Crystal Report 9)
See this article: http://support.microsoft.com/?id=129397 or just Google “PrtDevMode”
View Answer
| January 11, 2006 7:50 AM
Data analysis, Database, DB2, Oracle
See this article: http://support.microsoft.com/?id=129397 or just Google “PrtDevMode”
View Answer
| January 11, 2006 7:50 AM
Data analysis, Database, DB2, Oracle
Symantec Resources
Here’s my list of favorites: 1. www.Boardfish.com 2. www.Castlecops.com 3. www.Tek-tips.com Of the three, Boardfish.com is the only one dedicated to the Symantec product line. It’s new, but is getting a lot of attention from the media since Symantec closed their forums.
View Answer
| January 9, 2006 10:31 PM
Access control, Application security, backdoors, Backup & recovery, Brightmail, Browsers, Compliance, configuration, CRM, Current threats, Database, DataCenter, Desktop management applications, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, McAfee, Microsoft Windows, Network security, Patch management, patching, PEN testing, Platform Security, Policies, Risk management, Secure Coding, Security, Security Program Management, Servers, Software, Spam, Spyware, SSL/TLS, Symantec, Systems management software, Trojans, Veritas, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Here’s my list of favorites: 1. www.Boardfish.com 2. www.Castlecops.com 3. www.Tek-tips.com Of the three, Boardfish.com is the only one dedicated to the Symantec product line. It’s new, but is getting a lot of attention from the media since Symantec closed their forums.
View Answer
| January 9, 2006 10:31 PM
Access control, Application security, backdoors, Backup & recovery, Brightmail, Browsers, Compliance, configuration, CRM, Current threats, Database, DataCenter, Desktop management applications, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, McAfee, Microsoft Windows, Network security, Patch management, patching, PEN testing, Platform Security, Policies, Risk management, Secure Coding, Security, Security Program Management, Servers, Software, Spam, Spyware, SSL/TLS, Symantec, Systems management software, Trojans, Veritas, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Email encryption
Most direct way is to put a sniffer on the mail server’s port (either with a hub, or by using a SPAN port on the switch) and watch some emails. Your email administrators may also know, so it couldn’t hurt to ask them too. Bob
View Answer
| January 5, 2006 11:03 AM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding, Security
Most direct way is to put a sniffer on the mail server’s port (either with a hub, or by using a SPAN port on the switch) and watch some emails. Your email administrators may also know, so it couldn’t hurt to ask them too. Bob
View Answer
| January 5, 2006 11:03 AM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding, Security
Old Approach App in XP
My intial suggestion would be to upgrade to the latest version of your software. I was able to find several places online that offer the SmartSuite 9.8 package for $20 to $40 US in about 20 seconds of searching.
View Answer
| January 3, 2006 6:33 PM
Database, DB2, Development, Oracle, SQL
My intial suggestion would be to upgrade to the latest version of your software. I was able to find several places online that offer the SmartSuite 9.8 package for $20 to $40 US in about 20 seconds of searching.
View Answer
| January 3, 2006 6:33 PM
Database, DB2, Development, Oracle, SQL
Oracle Longops Queries.
Full table scans, sorts or parallel query processes where the total of blocks being scanned exceed 10,000 blocks or 6 seconds. That was what is was early on, in 10g this list may have grown somewhat, please check on 10g and 10 XE. Regards: Ferenc
View Answer
| January 2, 2006 4:59 PM
Database, DB2, Oracle, Windows
Full table scans, sorts or parallel query processes where the total of blocks being scanned exceed 10,000 blocks or 6 seconds. That was what is was early on, in 10g this list may have grown somewhat, please check on 10g and 10 XE. Regards: Ferenc
View Answer
| January 2, 2006 4:59 PM
Database, DB2, Oracle, Windows
ORA-01000 error even if all statements and resultsets are closed in finally
We are using Oracle 8.1.7 and in JDBC driver ‘Enable Resultset’ is ON and ‘Enable Closing cursors’ is OFF maybe you should first try ‘Enable Closing cursors’ ON Are you using bind variables? that would help a lot Also is the latest 8.1.7 patch installed, I remember having this problem a long time ago and [...]
View Answer
| December 29, 2005 7:58 AM
Database, DB2, Java, Oracle, Software, SQL, Tech support, Windows
We are using Oracle 8.1.7 and in JDBC driver ‘Enable Resultset’ is ON and ‘Enable Closing cursors’ is OFF maybe you should first try ‘Enable Closing cursors’ ON Are you using bind variables? that would help a lot Also is the latest 8.1.7 patch installed, I remember having this problem a long time ago and [...]
View Answer
| December 29, 2005 7:58 AM
Database, DB2, Java, Oracle, Software, SQL, Tech support, Windows
Educating database users
Hello Robyn, Just to clarify, the finger pointing is not always directed at just database admins, but at all members of the IT group, helpdesk right up to the programmers. And when that single digit points my way? Well I remind those users that they are welcome to fix it themselves @#!*! Or at least [...]
View Answer
| December 28, 2005 10:06 AM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
Hello Robyn, Just to clarify, the finger pointing is not always directed at just database admins, but at all members of the IT group, helpdesk right up to the programmers. And when that single digit points my way? Well I remind those users that they are welcome to fix it themselves @#!*! Or at least [...]
View Answer
| December 28, 2005 10:06 AM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
64 bit Oracle
Strange question? Why would you think that enterprise operations work best on Windows?? Basically, Linux requires a more knowledgeable operator; however you have a huge set of flexible options on Linux that you don’t have on Windows – a few are available on Windows for an additional cost. If you have an organization full of [...]
View Answer
| December 27, 2005 4:59 PM
Database, DB2, Oracle
Strange question? Why would you think that enterprise operations work best on Windows?? Basically, Linux requires a more knowledgeable operator; however you have a huge set of flexible options on Linux that you don’t have on Windows – a few are available on Windows for an additional cost. If you have an organization full of [...]
View Answer
| December 27, 2005 4:59 PM
Database, DB2, Oracle
ANNOUNCEMENT ? MORE NEW CATEGORIES ADDED TO THE ISERIES CATEGORY
Where have these new catagories been added?? Thanks
View Answer
| December 23, 2005 4:57 PM
AS/400, Backup & recovery, CLP, DB2 Universal Database, Printing, RPG, RPGLE, Security, Web development
Where have these new catagories been added?? Thanks
View Answer
| December 23, 2005 4:57 PM
AS/400, Backup & recovery, CLP, DB2 Universal Database, Printing, RPG, RPGLE, Security, Web development
Advice needed to move from DB2/400 flat-file system to Oracle
Try Visio. One of the advanced versions (I don’t remember ms’s naming convention) can reverse engineer a db. The iSeries as a DB2 instance is supported, and the ERD’s Visio generates are usable. You should be able to have visio traverse a schema and build the ERD, then export the DDL to Oracle.
View Answer
| December 22, 2005 8:24 AM
DB2 Universal Database
Try Visio. One of the advanced versions (I don’t remember ms’s naming convention) can reverse engineer a db. The iSeries as a DB2 instance is supported, and the ERD’s Visio generates are usable. You should be able to have visio traverse a schema and build the ERD, then export the DDL to Oracle.
View Answer
| December 22, 2005 8:24 AM
DB2 Universal Database
A DBA is required for the big iSeries server
Search400.com member “JohnDavid” responds: I have worked in some large AS/400 organizations with huge DB infrastructures and they appointed a specific person to manage their data bases: 1. Definition of tables and view 2. Referential integrity 3. Trigger programs 4. Changes to such definitions 5. Journals 6. Queries on journals 7. Monitor programs to identify [...]
View Answer
| December 22, 2005 6:38 AM
DB2 Universal Database
Search400.com member “JohnDavid” responds: I have worked in some large AS/400 organizations with huge DB infrastructures and they appointed a specific person to manage their data bases: 1. Definition of tables and view 2. Referential integrity 3. Trigger programs 4. Changes to such definitions 5. Journals 6. Queries on journals 7. Monitor programs to identify [...]
View Answer
| December 22, 2005 6:38 AM
DB2 Universal Database
Looking for good HIP.
You could try bluebox or Third Brigade, these are the best I have seen.
View Answer
| December 21, 2005 6:37 PM
Application security, backdoors, Biometrics, Compliance, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, Spyware, Trojans, Viruses, VPN, Wireless, worms
You could try bluebox or Third Brigade, these are the best I have seen.
View Answer
| December 21, 2005 6:37 PM
Application security, backdoors, Biometrics, Compliance, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, Spyware, Trojans, Viruses, VPN, Wireless, worms
Methods used to maintain the access path of a file
The 3 methods are defined on the Help for the MAINT parm from CRTPF, CHGPF, CRTLF, CHGLF. I have never had any reason to use *REBLD or *DLY. *IMMED *REBLD *DLY *IMMED The access path is continuously (immediately) maintained for each physical file member. The path is changed each time a record is changed, added [...]
View Answer
| December 21, 2005 6:01 PM
DB2 Universal Database
The 3 methods are defined on the Help for the MAINT parm from CRTPF, CHGPF, CRTLF, CHGLF. I have never had any reason to use *REBLD or *DLY. *IMMED *REBLD *DLY *IMMED The access path is continuously (immediately) maintained for each physical file member. The path is changed each time a record is changed, added [...]
View Answer
| December 21, 2005 6:01 PM
DB2 Universal Database
Remote Syslog with MySQL and PHP
Dear Eduado, You could always try the process described at: http://www.linuxsecurity.com/content/view/117384/49/ which appears to walk you through exactly what you need to do. Iain
View Answer
| December 20, 2005 6:27 PM
3Com, Active Directory, Availability, Avaya, Bandwidth, Benchmarking, Billing and customer care, Billing Support Systems, Bind, Cabling, Cisco, Dell, Development, DHCP, DNS, Enterasys, Enterprise Desktop, Ethernet, Fault isolation, FDDI, Foundry, Frame Relay, H.323, Hardware, Hewlett-Packard, Hubs, IPv4, IPv6, Juniper Networks, Linux, Lucent, MPLS, MySQL, NetBIOS, Network management software, Network monitoring, Network protocols, Networking, Networking services, Nortel, Novell IPX/SPX, Performance management, Protocol analysis, Remote management, Routers, SIP, Switches, TCP
Dear Eduado, You could always try the process described at: http://www.linuxsecurity.com/content/view/117384/49/ which appears to walk you through exactly what you need to do. Iain
View Answer
| December 20, 2005 6:27 PM
3Com, Active Directory, Availability, Avaya, Bandwidth, Benchmarking, Billing and customer care, Billing Support Systems, Bind, Cabling, Cisco, Dell, Development, DHCP, DNS, Enterasys, Enterprise Desktop, Ethernet, Fault isolation, FDDI, Foundry, Frame Relay, H.323, Hardware, Hewlett-Packard, Hubs, IPv4, IPv6, Juniper Networks, Linux, Lucent, MPLS, MySQL, NetBIOS, Network management software, Network monitoring, Network protocols, Networking, Networking services, Nortel, Novell IPX/SPX, Performance management, Protocol analysis, Remote management, Routers, SIP, Switches, TCP
Print Numbers in words
Although it’s entirely possible, build a function to do it. Here’s an example function written for DB2 in C: Define TO_WORDS(DECIMAL(11,2)) RETURNS VARCHAR as an external function named to_words. Here’s the C definition: void to_words(char *result, _Decimal(11,2) *arg, short *outNull, short *inNull) { _Decimal(11,2) value = *arg; // Hold local copy *result = 0; // [...]
View Answer
| December 19, 2005 12:53 AM
Career development, Certifications, CRM, Database, DataManagement, DB2, Desktops, Development, Functional, Lifecycle development, Management, Microsoft Windows, Oracle, OS, Performance/Load, Security, Servers, Software, Software Quality Assurance, Software testing tools, SQL, SQL Server, Tech support, Windows
Although it’s entirely possible, build a function to do it. Here’s an example function written for DB2 in C: Define TO_WORDS(DECIMAL(11,2)) RETURNS VARCHAR as an external function named to_words. Here’s the C definition: void to_words(char *result, _Decimal(11,2) *arg, short *outNull, short *inNull) { _Decimal(11,2) value = *arg; // Hold local copy *result = 0; // [...]
View Answer
| December 19, 2005 12:53 AM
Career development, Certifications, CRM, Database, DataManagement, DB2, Desktops, Development, Functional, Lifecycle development, Management, Microsoft Windows, Oracle, OS, Performance/Load, Security, Servers, Software, Software Quality Assurance, Software testing tools, SQL, SQL Server, Tech support, Windows
Outlook Express compacting
If you want to keep messages, do not put them in the delete folder for starters. Create folders to store them in and store them on your PC hard drive instead of in the delete folder. Syncronize will help you do this. The delete folder is just that, one step from being gone forever. You [...]
View Answer
| December 15, 2005 5:01 PM
Application security, Backup & recovery, Database, Encryption, Exchange, Exchange security, Instant Messaging, Secure Coding, Tech support
If you want to keep messages, do not put them in the delete folder for starters. Create folders to store them in and store them on your PC hard drive instead of in the delete folder. Syncronize will help you do this. The delete folder is just that, one step from being gone forever. You [...]
View Answer
| December 15, 2005 5:01 PM
Application security, Backup & recovery, Database, Encryption, Exchange, Exchange security, Instant Messaging, Secure Coding, Tech support
Looking for a utility to list all used queries and files
look at http://search400.techtarget.com/ITKnowledgeExchange/viewMessage/0,294934,sid3_gci1152096,00.html
View Answer
| December 15, 2005 8:32 AM
DB2 Universal Database
look at http://search400.techtarget.com/ITKnowledgeExchange/viewMessage/0,294934,sid3_gci1152096,00.html
View Answer
| December 15, 2005 8:32 AM
DB2 Universal Database
Oracle HA Database Architecture on Linux
That is a pretty broad question. We would need to know more about the applicatoin or the environment. A good RAC installation is quite resilient but you have to remember that there are still single points of failure. ASM is a big one that has caught me out also CRS corruption is another. You lose [...]
View Answer
| December 13, 2005 7:07 PM
Database, DB2, Oracle
That is a pretty broad question. We would need to know more about the applicatoin or the environment. A good RAC installation is quite resilient but you have to remember that there are still single points of failure. ASM is a big one that has caught me out also CRS corruption is another. You lose [...]
View Answer
| December 13, 2005 7:07 PM
Database, DB2, Oracle
