Database cleanup
Background: Oracle 9.2.0 running on win2k q1: I need to find out which objects have not been in used for > 6 mths. How do i do this? q2: Before i delete an object, eg, an index, materialized view, view, i need a query to find what are its dependency, so that i would know [...]
Answer Question
| November 4, 2005 10:42 PM
Database, DB2, Oracle
Background: Oracle 9.2.0 running on win2k q1: I need to find out which objects have not been in used for > 6 mths. How do i do this? q2: Before i delete an object, eg, an index, materialized view, view, i need a query to find what are its dependency, so that i would know [...]
Answer Question
| November 4, 2005 10:42 PM
Database, DB2, Oracle
execute dbms_utility.analyze_schema
I tried to run the floowing command : execute dbms_utility.analyze_schema(‘CALLSINFO’,'ESTIMATE’,500,0,’for table for all indexes for all indexed columns’); and i am having this error: ERROR at line 1: ORA-00376: file 1629 cannot be read at this time ORA-01110: data file 1629: ‘G:ORADATACDRSTS_SMS_MT_NOV2006_FILE#02.DF’ ORA-06512: at “SYS.DBMS_DDL”, line 179 ORA-06512: at “SYS.DBMS_UTILITY”, line 472 ORA-06512: at line [...]
Answer Question
| June 4, 2012 3:12 PM
Database, DB2, Oracle
I tried to run the floowing command : execute dbms_utility.analyze_schema(‘CALLSINFO’,'ESTIMATE’,500,0,’for table for all indexes for all indexed columns’); and i am having this error: ERROR at line 1: ORA-00376: file 1629 cannot be read at this time ORA-01110: data file 1629: ‘G:ORADATACDRSTS_SMS_MT_NOV2006_FILE#02.DF’ ORA-06512: at “SYS.DBMS_DDL”, line 179 ORA-06512: at “SYS.DBMS_UTILITY”, line 472 ORA-06512: at line [...]
Answer Question
| June 4, 2012 3:12 PM
Database, DB2, Oracle
Windows 2000 / 2003 Server Log Management
Hi All, I am an IT Security Administrator of my company. i need to audit more than 100 Windows servers for systems logs, event logs , anti virus server logs almost every month. I am looking out for automated tools that can help me make my work easier. A product with a good reporting tool [...]
Answer Question
| October 19, 2005 10:53 AM
Access, Access control, Application security, backdoors, Biometrics, Browsers, Career development, Compliance, configuration, CRM, Current threats, Data analysis, Data mining/analysis, Database, Desktop management applications, Desktops, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, IBM, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Laws, Management, Microsoft Office, Microsoft Windows, Network security, OS, Patch management, patching, PEN testing, Platform Security, Policies, Project management, provisioning, Regulations, Remote management, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, standards, Trojans, Updates from SearchCRM.com staff, Updates from SearchWindowsSecurity.com staff, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Hi All, I am an IT Security Administrator of my company. i need to audit more than 100 Windows servers for systems logs, event logs , anti virus server logs almost every month. I am looking out for automated tools that can help me make my work easier. A product with a good reporting tool [...]
Answer Question
| October 19, 2005 10:53 AM
Access, Access control, Application security, backdoors, Biometrics, Browsers, Career development, Compliance, configuration, CRM, Current threats, Data analysis, Data mining/analysis, Database, Desktop management applications, Desktops, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, IBM, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Laws, Management, Microsoft Office, Microsoft Windows, Network security, OS, Patch management, patching, PEN testing, Platform Security, Policies, Project management, provisioning, Regulations, Remote management, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, standards, Trojans, Updates from SearchCRM.com staff, Updates from SearchWindowsSecurity.com staff, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Need help with max function within a left outer join
I need to search for a max timestamp of a column within a left outer join statement. I have tried many different combinations unsuccessfully.
Answer Question
| October 19, 2005 8:57 AM
Database, DB2, Oracle, SQL
I need to search for a max timestamp of a column within a left outer join statement. I have tried many different combinations unsuccessfully.
Answer Question
| October 19, 2005 8:57 AM
Database, DB2, Oracle, SQL
Upgrade OS from V4R5 to V5R2 and SQL stopped working
Hi, We have just upgraded from V4R5 to V5R2 and have difficulty running an interactive SQL statement that worked fine at R4R5. The statement is as follows: update grmlib/mspmp100 as t1 set pmfp2=(select pmfp2 from grmlib/sin gupl2 as t2 where t1.prdno=t2.prdno and t2.pmfp2<>0) Previously this returned the following result: 674 rows updated in MSPMP100 in [...]
Answer Question
| October 18, 2005 6:42 AM
Database, DB2 Universal Database
Hi, We have just upgraded from V4R5 to V5R2 and have difficulty running an interactive SQL statement that worked fine at R4R5. The statement is as follows: update grmlib/mspmp100 as t1 set pmfp2=(select pmfp2 from grmlib/sin gupl2 as t2 where t1.prdno=t2.prdno and t2.pmfp2<>0) Previously this returned the following result: 674 rows updated in MSPMP100 in [...]
Answer Question
| October 18, 2005 6:42 AM
Database, DB2 Universal Database
SOS: Configuring Microsoft IIS6 to receive emails addressed to postmaster@69.59.X.X and / or abuse@69.59.X.X
Hi !! Heres the scenario: I have a webserver which is running windows 2003, IIS 6 & SMTP service. It has a public IP address assigned to it – 69.59.X.X I have a .net application which generates email and sends out the same using the my SMTP server on IP address 69.59.X.X During the pre-release [...]
Answer Question
| October 22, 2005 6:07 AM
Application security, Database, DataCenter, Encryption, Exchange, Instant Messaging, Secure Coding
Hi !! Heres the scenario: I have a webserver which is running windows 2003, IIS 6 & SMTP service. It has a public IP address assigned to it – 69.59.X.X I have a .net application which generates email and sends out the same using the my SMTP server on IP address 69.59.X.X During the pre-release [...]
Answer Question
| October 22, 2005 6:07 AM
Application security, Database, DataCenter, Encryption, Exchange, Instant Messaging, Secure Coding
how can an application disable/enable a user account in active directory??
How can a fingerprint reader be used to disable/enable a user account?? Could I use a VBscript to do this?
Answer Question
| October 18, 2005 4:22 AM
Application security, Biometrics, Compliance, CRM, Database, Desktops, Digital certificates, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Windows, Network security, OS, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, SQL Server, VPN, Wireless
How can a fingerprint reader be used to disable/enable a user account?? Could I use a VBscript to do this?
Answer Question
| October 18, 2005 4:22 AM
Application security, Biometrics, Compliance, CRM, Database, Desktops, Digital certificates, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Windows, Network security, OS, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, SQL Server, VPN, Wireless
CPYTOPCD command.
Are any of you familiar with this command? Can this be used to copy something from the AS400 to a shared folder on a Windows system, or do any of you know how to accomplish this?
Answer Question
| November 16, 2009 4:12 PM
AS/400, Database, DB2 Universal Database, RPG
Are any of you familiar with this command? Can this be used to copy something from the AS400 to a shared folder on a Windows system, or do any of you know how to accomplish this?
Answer Question
| November 16, 2009 4:12 PM
AS/400, Database, DB2 Universal Database, RPG
user password auditing
We have recently purchased LC5 to perform password audits to discover weak passwords. The documentation indicates to use PWDUMP3 to extract password hashes from the Active Directory. I have looked everywhere and cannot find a legitimate site to download this tool nor can I find documentation. Has anyone ever used this tool that can shed [...]
Answer Question
| October 19, 2005 7:35 AM
Access control, Application security, backdoors, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
We have recently purchased LC5 to perform password audits to discover weak passwords. The documentation indicates to use PWDUMP3 to extract password hashes from the Active Directory. I have looked everywhere and cannot find a legitimate site to download this tool nor can I find documentation. Has anyone ever used this tool that can shed [...]
Answer Question
| October 19, 2005 7:35 AM
Access control, Application security, backdoors, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
E-mail hacking
How can I hack my own e-mail address? Is there software available for this (commercial or freeware)?
Answer Question
| December 5, 2010 3:49 PM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding
How can I hack my own e-mail address? Is there software available for this (commercial or freeware)?
Answer Question
| December 5, 2010 3:49 PM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding
AS/400 – iSeries SQL Update of on table with values from another joined table
I’ve use an SQL utility on the AS/400 call SEQUEL by ASC, that allows updating of values in one table from values in another joined table. The syntax is something like this: update set((a.fld1=b.fld1)(a.fld2=b.fld2)) from file1 a join file2 b on a.key1=b.key1 where a.key1='OnlyTheOneIWant' I no longer have access to the SEQUEL tool, and I’m [...]
Answer Question
| May 8, 2013 1:34 PM
AS/400, DB2 Universal Database, SQL
I’ve use an SQL utility on the AS/400 call SEQUEL by ASC, that allows updating of values in one table from values in another joined table. The syntax is something like this: update set((a.fld1=b.fld1)(a.fld2=b.fld2)) from file1 a join file2 b on a.key1=b.key1 where a.key1='OnlyTheOneIWant' I no longer have access to the SEQUEL tool, and I’m [...]
Answer Question
| May 8, 2013 1:34 PM
AS/400, DB2 Universal Database, SQL
CPYF in arrival sequence
Anyone know a quick and dirty to copy data from a keyed physical file to another physical in arrival sequence in a CLP program? I can’t find a native os/400 command that will do it.
Answer Question
| November 15, 2009 1:28 PM
AS/400, DB2 Universal Database
Anyone know a quick and dirty to copy data from a keyed physical file to another physical in arrival sequence in a CLP program? I can’t find a native os/400 command that will do it.
Answer Question
| November 15, 2009 1:28 PM
AS/400, DB2 Universal Database
HTTP File upload/post Blocking
In this ever expanding world of network security I am seeking a software or appliance to block HTTP file uploads or post. The problem in a nutshell is I cannot block all of the HTML based Email providers. I also cannot block all of the web sites that support HTTP file posting. I am seeking [...]
Answer Question
| October 17, 2005 10:34 AM
Access control, Application security, backdoors, Browsers, Current threats, Database, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, Network protocols, Network security, Networking, Secure Coding, Security, Servers, Spyware, SSL/TLS, TCP, Trojans, Viruses, VPN, Web security, Wireless, worms
In this ever expanding world of network security I am seeking a software or appliance to block HTTP file uploads or post. The problem in a nutshell is I cannot block all of the HTML based Email providers. I also cannot block all of the web sites that support HTTP file posting. I am seeking [...]
Answer Question
| October 17, 2005 10:34 AM
Access control, Application security, backdoors, Browsers, Current threats, Database, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, Network protocols, Network security, Networking, Secure Coding, Security, Servers, Spyware, SSL/TLS, TCP, Trojans, Viruses, VPN, Web security, Wireless, worms
ODBC Request from iSeries to Excel
I am trying to use an ODBC DSN I have created, that uses the iSeries Access for Windows Driver, to download data from a file in QUSRSYS, to Excel. I have to download from QUSRSYS because the file is IBM supplied. Note: QUSRSYS appears in QSYSLIBL system value. The problem I have is that unless [...]
Answer Question
| November 15, 2009 9:54 AM
AS/400, DB2 Universal Database, Microsoft Office, SQL
I am trying to use an ODBC DSN I have created, that uses the iSeries Access for Windows Driver, to download data from a file in QUSRSYS, to Excel. I have to download from QUSRSYS because the file is IBM supplied. Note: QUSRSYS appears in QSYSLIBL system value. The problem I have is that unless [...]
Answer Question
| November 15, 2009 9:54 AM
AS/400, DB2 Universal Database, Microsoft Office, SQL
AS400 SQL
Is anyone using a third party product that maes AS400 SQL easier and more user frienfly?
Answer Question
| October 13, 2005 10:19 AM
DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Is anyone using a third party product that maes AS400 SQL easier and more user frienfly?
Answer Question
| October 13, 2005 10:19 AM
DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
How to use API to access DB2 file on iSeries
Gredon would like to access (search, read, insert, update and delete) a DB2 file on the iSeries with an API. He said he’s searched the IBM manual, but he couldn’t find the APIs that he can use. Can you help him? – Michelle Davidson, editor, Search400.com
Answer Question
| November 15, 2009 10:23 AM
AS/400, DB2 Universal Database
Gredon would like to access (search, read, insert, update and delete) a DB2 file on the iSeries with an API. He said he’s searched the IBM manual, but he couldn’t find the APIs that he can use. Can you help him? – Michelle Davidson, editor, Search400.com
Answer Question
| November 15, 2009 10:23 AM
AS/400, DB2 Universal Database
Oracle Hash Partitioning.
Hi, In Oracle hash paritioning do we have control over hash value based on which partitioning is done? My issue is – We have to make a design for datawarehouse application and in the landing area we are planning for range-hash partitionining based on the keys (and their volumes). Now, if we use range-hash paritioning, [...]
Answer Question
| October 14, 2005 1:06 AM
Business Objects, Data analysis, Data warehousing applications, Database, DB2, Oracle, Windows
Hi, In Oracle hash paritioning do we have control over hash value based on which partitioning is done? My issue is – We have to make a design for datawarehouse application and in the landing area we are planning for range-hash partitionining based on the keys (and their volumes). Now, if we use range-hash paritioning, [...]
Answer Question
| October 14, 2005 1:06 AM
Business Objects, Data analysis, Data warehousing applications, Database, DB2, Oracle, Windows
Why do IT projects fail?-3
Hi, I’m a Computer Engineering at CSU Chico. I’m conducting a research paper on “Why IT Projects Fail”. If someone could give me an example of a failed projects, “failed” meaning that it didn’t get finished on time, or the final project did not meet the requierments. Also if you could give a quick description [...]
Answer Question
| September 30, 2008 3:10 PM
390, Cabling, Career development, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Desktops, Development, Hardware, Hubs, Linux, Mainframe, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Patch management, Project management, Routers, Security, Servers, Software Quality Assurance, Software testing, SQL Server, Switches, Tech support
Hi, I’m a Computer Engineering at CSU Chico. I’m conducting a research paper on “Why IT Projects Fail”. If someone could give me an example of a failed projects, “failed” meaning that it didn’t get finished on time, or the final project did not meet the requierments. Also if you could give a quick description [...]
Answer Question
| September 30, 2008 3:10 PM
390, Cabling, Career development, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Desktops, Development, Hardware, Hubs, Linux, Mainframe, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Patch management, Project management, Routers, Security, Servers, Software Quality Assurance, Software testing, SQL Server, Switches, Tech support
Why do IT projects fail?-2
Hi, I’m a Computer Engineering at CSU Chico. I’m conducting a research paper on “Why IT Projects Fail”. If someone could give me an example of a failed projects, “failed” meaning that it didn’t get finished on time, or the final project did not meet the requierments. Also if you could give a quick description [...]
Answer Question
| October 10, 2005 3:10 PM
390, Business/IT alignment, Cabling, Career development, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Desktops, Development, Hardware, Hubs, Linux, Mainframe, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Patch management, Routers, Security, Servers, Software Quality Assurance, Software testing, SQL Server, Switches, Tech support
Hi, I’m a Computer Engineering at CSU Chico. I’m conducting a research paper on “Why IT Projects Fail”. If someone could give me an example of a failed projects, “failed” meaning that it didn’t get finished on time, or the final project did not meet the requierments. Also if you could give a quick description [...]
Answer Question
| October 10, 2005 3:10 PM
390, Business/IT alignment, Cabling, Career development, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Desktops, Development, Hardware, Hubs, Linux, Mainframe, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Patch management, Routers, Security, Servers, Software Quality Assurance, Software testing, SQL Server, Switches, Tech support
Windows 2000 Active Directory customizer
I am working on a Windows 2000 Active Directory and am trying to achieve the following: 1. Users are not allowed to logon to more than 1 PC 2. The PCs must autoshutdown after some idle time, even during logoff 3. Keep track of each user’s login duration 4. All logon accounts should be disabled [...]
Answer Question
| October 10, 2005 8:34 AM
Active Directory, Application security, Compliance, CRM, Database, Desktop management applications, Development, DHCP, Disaster Recovery, DNS, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Microsoft Windows, Network applications management, Network management software, Network monitoring, Network security, Networking, Networking services, Novell NDS, Policies, Risk management, Secure Coding, Security Program Management, VPN, Wireless
I am working on a Windows 2000 Active Directory and am trying to achieve the following: 1. Users are not allowed to logon to more than 1 PC 2. The PCs must autoshutdown after some idle time, even during logoff 3. Keep track of each user’s login duration 4. All logon accounts should be disabled [...]
Answer Question
| October 10, 2005 8:34 AM
Active Directory, Application security, Compliance, CRM, Database, Desktop management applications, Development, DHCP, Disaster Recovery, DNS, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Microsoft Windows, Network applications management, Network management software, Network monitoring, Network security, Networking, Networking services, Novell NDS, Policies, Risk management, Secure Coding, Security Program Management, VPN, Wireless
